| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |