Re: ext4 finally doing the right thing

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: ext4 finally doing the right thing
Дата
Msg-id 4B582452020000250002E95B@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: ext4 finally doing the right thing  (Aidan Van Dyk <aidan@highrise.ca>)
Список pgsql-performance
>Aidan Van Dyk <aidan@highrise.ca> wrote:
> But, I think that's one of the reasons people usually recommend
> putting WAL separate. Even if it's just another partition on the
> same (set of) disk(s), you get the benefit of not having to wait
> for all the dirty ext3 pages from your whole database FS to be
> flushed before the WAL write can complete on it's own FS.

[slaps forehead]

I've been puzzling about why we're getting timeouts on one of two
apparently identical (large) servers.  We forgot to move the pg_xlog
directory to the separate mount point we created for it on the same
RAID.  I didn't think to check that until I saw your post.

-Kevin

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: New server to improve performance on our large and busy DB - advice?
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: Inserting 8MB bytea: just 25% of disk perf used?