Re: limiting performance impact of wal archiving.

Поиск
Список
Период
Сортировка
Искать
От
david@lang.hm
Тема
Re: limiting performance impact of wal archiving.
Дата
Msg-id
alpine.DEB.2.00.0911151454140.6163@asgard.lang.hm
Ответ на
Список
Дерево обсуждения
limiting performance impact of wal archiving. Laurent Laborde <kerdezixe@gmail.com>
Re: limiting performance impact of wal archiving. Kenneth Marshall <ktm@rice.edu>
Re: limiting performance impact of wal archiving. Ivan Voras <ivoras@freebsd.org>
Re: limiting performance impact of wal archiving. Laurent Laborde <kerdezixe@gmail.com>
Re: limiting performance impact of wal archiving. Scott Marlowe <scott.marlowe@gmail.com>
Re: limiting performance impact of wal archiving. Ivan Voras <ivoras@freebsd.org>
Re: limiting performance impact of wal archiving. Laurent Laborde <kerdezixe@gmail.com>
Re: limiting performance impact of wal archiving. "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: limiting performance impact of wal archiving. Laurent Laborde <kerdezixe@gmail.com>
Re: limiting performance impact of wal archiving. Jeff <threshar@torgo.978.org>
Re: limiting performance impact of wal archiving. Greg Smith <greg@2ndquadrant.com>
Re: limiting performance impact of wal archiving. Laurent Laborde <kerdezixe@gmail.com>
Re: limiting performance impact of wal archiving. Craig James <craig_james@emolecules.com>
Re: limiting performance impact of wal archiving. Greg Smith <greg@2ndquadrant.com>
Re: limiting performance impact of wal archiving. Scott Carey <scott@richrelevance.com>
Re: limiting performance impact of wal archiving. Greg Smith <greg@2ndquadrant.com>
Re: limiting performance impact of wal archiving. Laurent Laborde <kerdezixe@gmail.com>
Re: limiting performance impact of wal archiving. Laurent Laborde <kerdezixe@gmail.com>
Re: limiting performance impact of wal archiving. Scott Marlowe <scott.marlowe@gmail.com>
Re: limiting performance impact of wal archiving. Greg Smith <greg@2ndquadrant.com>
Re: limiting performance impact of wal archiving. Scott Marlowe <scott.marlowe@gmail.com>
Re: limiting performance impact of wal archiving. Greg Smith <greg@2ndquadrant.com>
Re: limiting performance impact of wal archiving. Scott Marlowe <scott.marlowe@gmail.com>
Re: limiting performance impact of wal archiving. david@lang.hm
Re: limiting performance impact of wal archiving. Laurent Laborde <kerdezixe@gmail.com>
On Tue, 10 Nov 2009, Greg Smith wrote:

> Laurent Laborde wrote:
>> It is on a separate array which does everything but tablespace (on a
>> separate array) and indexspace (another separate array).
>> 
> On Linux, the types of writes done to the WAL volume (where writes are 
> constantly being flushed) require the WAL volume not be shared with anything 
> else for that to perform well.  Typically you'll end up with other things 
> being written out too because it can't just selectively flush just the WAL 
> data.  The whole "write barriers" implementation should fix that, but in 
> practice rarely does.

I believe that this is more a EXT3 problem than a linux problem.

David Lang

В списке pgsql-performance по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ