2010/10/21 Leonardo Francalanci <m_lists@yahoo.it>:
>> 2010-10-21 16:39:15 CEST LOG: checkpoint complete: wrote 365 buffers
>> (11.9%); 0 transaction log file(s) added, 0 removed, 3 recycled;
>> write=0.403 s, sync=21.312 s, total=21.829 s
>
>
> I'm no expert, but isn't 21s to sync 365 buffers a big amount of time?
It is.
I suggest to look at /proc/meminfo about dirty buffers and the results
of 'iostat -x 2' runing for some moment
>
>
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--
Cédric Villemain 2ndQuadrant
http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support