Re: [PERFORM] Queries related to checkpoints

2011-07-29 Thread Kevin Grittner
Rohan Malhotra wrote: First off, for a one-row result with too many values to fit on one line, you might want to use this in psql: \x on More importantly, you seem to be misinterpreting the numbers. You've allocated 2,205,969,940 buffers. Of those allocations, the allocating backend had t

[PERFORM] Queries related to checkpoints

2011-07-29 Thread Rohan Malhotra
Hi, I am a Noob with db tuning and trying to analyze pg_stats_brwriter data checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend | buffers_alloc ---+-++---+--