understanding postgres stats

From: Ryan Chambers <ryan(at)squaretrade(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: understanding postgres stats
Date: 2003-10-15 21:34:39
Message-ID: 3F8DBD6F.80905@squaretrade.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I've recently enabled statistics gathering on our large (> 50GB)
postgres database because of a recent significant decrease in
performance, believed to be related to changes in the application
running on top of it. I'm trying to make sense of these statistics in my
investigation of this. Are there any rules-of-thumb used when looking at
them? For example the ratio of idx_scan to idx_tup_fetch in
pg_stat_user_tables, or heap_blks_read to heap_blks_hit in
pg_statio_user_tables.

I'm assuming that the answer will be "Well, it really depends on your
database/application", but if anybody has any quick rules of thumb, I'd
love to hear them.

I've found a lot of advice on the web for optimizing postgres databases,
and so I don't need that kind of info.

Thanks in advance.

Ryan

Browse pgsql-admin by date

  From Date Subject
Next Message Ben Kim 2003-10-15 21:45:39 question re double quotes
Previous Message b p 2003-10-15 18:54:19 problems with missing bin