| From: | Euler Taveira <euler(at)timbira(dot)com> |
|---|---|
| To: | Satoshi Nagayasu <snaga(at)uptime(dot)jp> |
| Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: New statistics for WAL buffer dirty writes |
| Date: | 2012-07-07 13:07:39 |
| Message-ID: | 4FF8349B.4080507@timbira.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 07-07-2012 09:00, Satoshi Nagayasu wrote:
> I've created new patch to get/reset statistics of WAL buffer
> writes (flushes) caused by WAL buffer full.
>
This new statistic doesn't solve your problem (tune wal_buffers). It doesn't
give you the wal_buffers value. It only says "hey, I needed more buffers so I
write those dirty ones". It doesn't say how many. I would like to have
something that says "hey, you have 1000 buffers available and you are using
100 buffers (10%)". This new statistic is only useful for decreasing the
WALWriteLock contention.
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Satoshi Nagayasu | 2012-07-07 13:36:45 | Re: New statistics for WAL buffer dirty writes |
| Previous Message | Pavel Stehule | 2012-07-07 12:57:35 | Re: enhanced error fields |