| From: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com> |
|---|---|
| To: | 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:40:12 |
| Message-ID: | AANLkTikmHRiGFLD2bW2zYBHPNb0V8y69avs-yjeoL8Zb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
2010/10/21 Leonardo Francalanci <m_lists(at)yahoo(dot)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(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2010-10-21 15:45:11 | Re: New wiki page on write reliability |
| Previous Message | Leonardo Francalanci | 2010-10-21 15:30:15 | Re: Periodically slow inserts |