Re: Need to tune for Heavy Write

Поиск
Список
Период
Сортировка
От Nicholson, Brad (Toronto, ON, CA)
Тема Re: Need to tune for Heavy Write
Дата
Msg-id 2626AEE4839D064CB0472A3814DC403F46DA2F2222@GVW1092EXB.americas.hpqcorp.net
обсуждение исходный текст
Ответ на Re: Need to tune for Heavy Write  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Need to tune for Heavy Write  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-
> owner@postgresql.org] On Behalf Of Scott Marlowe
> Sent: Thursday, August 04, 2011 4:46 AM
> To: Willy-Bas Loos
> Cc: Adarsh Sharma; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Need to tune for Heavy Write
>
>
> > Moving the pg_xlog to a different directory only helps when that
> > directory is on a different harddisk (or whatever I/O device).
>
> Not entirely true.  By simply being on a different  mounted file
> system this moves the fsync calls on the pg_xlog directories off of
> the same file system as the main data store.  Previous testing has
> shown improvements in performance from just using a different file
> system.
>

Is this still the case for xfs or ext4 where fsync is properly flushing only the correct blocks to disk, or was this
referringto the good old ext3 flush everything on fysnc issue? 

Brad.


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

Предыдущее
От: Dusan Misic
Дата:
Сообщение: Re: Need to tune for Heavy Write
Следующее
От: Nassib Nassar
Дата:
Сообщение: Seq Scan vs. Index Scan