> 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?
The view pg_statio_all_tables will show you the number of
disk reads and buffer hits per table.
There are other statistics views, see
> Another question is, what is the best memory configuration to
> keep more data in cache?
That's easy - the greater shared_buffers is, the more cache you have.
Another option is to choose shared_buffers not too large and let
the filesystem cache buffer the database for you.
In response to
pgsql-performance by date
|Next:||From: decibel||Date: 2009-10-16 16:30:51|
|Subject: Re: UUID as primary key|
|Previous:||From: keshav upadhyaya||Date: 2009-10-16 06:24:44|
|Subject: Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()|