2010/10/21 Leonardo Francalanci <m_lists@xxxxxxxx>: >> 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@xxxxxxxxxxxxxx) > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
