Skip site navigation (1) Skip section navigation (2)

Re: Periodically slow inserts

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To:
Cc: Gael Le Mignot <gael(at)pilotsystems(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Periodically slow inserts
Date: 2010-10-21 15:30:15
Message-ID: 219937.1152.qm@web29012.mail.ird.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
> 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?



      

In response to

Responses

pgsql-performance by date

Next:From: Cédric VillemainDate: 2010-10-21 15:40:12
Subject: Re: Periodically slow inserts
Previous:From: Leonardo FrancalanciDate: 2010-10-21 15:11:15
Subject: Re: Periodically slow inserts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group