Re: What exactly is postgres doing during INSERT/UPDATE ?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: What exactly is postgres doing during INSERT/UPDATE ?
Дата
Msg-id f67928030908281719g42938b1ay3a9edeed562688f1@mail.gmail.com
обсуждение исходный текст
Ответ на What exactly is postgres doing during INSERT/UPDATE ?  (Joseph S <jks@selectacast.net>)
Ответы Re: What exactly is postgres doing during INSERT/UPDATE ?
Список pgsql-performance
---------- Forwarded message ----------
From: Joseph S <jks@selectacast.net>
To: Greg Smith <gsmith@gregsmith.com>, pgsql-performance@postgresql.org
Date: Fri, 28 Aug 2009 10:25:10 -0400
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?
Greg Smith wrote:

The main two things you can do to improve this on the database side:

-Increase checkpoint_segments, which reduces how often updated data has to be flushed to disk

It fsync is turned off, does this matter so much?

It still matters.  The kernel is only willing to have so much dirty data sitting in the disk cache.  Once it reaches that limit, user processes doing writes start blocking while the kernel flushes stuff on their behalf.

Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Memory monitoring tool
Следующее
От: Luke Koops
Дата:
Сообщение: Re: What exactly is postgres doing during INSERT/UPDATE ?