Queries related to checkpoints

From: Rohan Malhotra <yourbuddyrohan(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Queries related to checkpoints
Date: 2011-07-29 13:37:15
Message-ID: CAEoM48XcWVaOU11L9CaDyMXo2kGUhA6ryPCx6kkaU1HX1zLm1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

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

-------------------+-----------------+--------------------+---------------+------------------+-----------------+---------------+------
35241 | 58 | 699136 | 581839 |
1597 | 1663650 | 2205969940

Almost all checkpoints (99.8%) that happened are because of
checkpoint_timeout passing. Is this good or should I increaase my
checkpoint_segments?
During checkpoints, 699136 8K buffers were written out which is pretty low
(less than 1MB).

buffers allocated (2205969940 8K), 1663650 times a database backend
(probably the client itself) had to write a page in order to make space for
the new allocation. Buffer allocated seems to be too high than backend
buffers.

How to read more into the data?

Regards
Rohan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-07-29 13:40:31 Re: repmgr and archive_mode
Previous Message Willy-Bas Loos 2011-07-29 13:26:49 how much work_mem is my server using

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2011-07-29 15:25:38 Re: [PERFORM] Queries related to checkpoints
Previous Message Robert Haas 2011-07-29 00:25:20 Re: very large record sizes and ressource usage