Postgres Pro
Downloads
Home   >   mailing lists

Re: Periodically slow inserts - Mailing list pgsql-performance

From Leonardo Francalanci
Subject Re: Periodically slow inserts
Date
Msg-id 219937.1152.qm@web29012.mail.ird.yahoo.com
Whole thread Raw
In response to Re: Periodically slow inserts  (Gael Le Mignot <gael@pilotsystems.net>)
Responses Re: Periodically slow inserts
List pgsql-performance
Tree view 
> 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?

pgsql-performance by date:

Previous
From: Leonardo Francalanci
Date:
Subject: Re: Periodically slow inserts
Next
From: Greg Smith
Date:
Subject: Re: New wiki page on write reliability