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

Re: Periodically slow inserts

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group