There is a statistic table?

From: waldomiro <waldomiro(at)shx(dot)com(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: There is a statistic table?
Date: 2009-10-16 03:33:47
Message-ID: 20091016033347.3737.qmail@hm929.locaweb.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Helo everbody!

I need to know how much the postgres is going to disk to get blocks and how much it is going to cache? witch is the statistic table and what is the field that indicates blocks reads from the disk and the memory cache?

Another question is, what is the best memory configuration to keep more data in cache?

Thanks,

Waldomiro

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-10-16 04:27:54 Re: There is a statistic table?
Previous Message Anj Adu 2009-10-15 20:51:45 Re: sequential scan on child partition tables