Re: Backport of fsync queue compaction

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Backport of fsync queue compaction
Дата
Msg-id 201206200021.57705.andres@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Backport of fsync queue compaction  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Backport of fsync queue compaction  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
On Tuesday, June 19, 2012 11:39:46 PM Robert Haas wrote:
> On Tue, Jun 19, 2012 at 5:33 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> > In January of 2011 Robert committed
> > 7f242d880b5b5d9642675517466d31373961cf98 to try and compact the fsync
> > queue when clients find it full.  There's no visible behavior change,
> > just a substantial performance boost possible in the rare but extremely
> > bad situations where the background writer stops doing fsync absorption.
> >  I've been running that in production at multiple locations since
> > practically the day it hit this mailing list, with backports all the way
> > to 8.3 being common (and straightforward to construct).  I've never seen
> > a hint of a problem with this new code.
> 
> I've been in favor of back-porting this for a while, so you'll get no
> argument from me.
> 
> Anyone disagree?
Not me, I have seen several sites having problems as well.

+1

Andres
-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [PATCH 10/16] Introduce the concept that wal has a 'origin' node
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: WAL format changes