Re: LVM and Postgres

Поиск
Список
Период
Сортировка
От Kevin Brown
Тема Re: LVM and Postgres
Дата
Msg-id 20051207041445.GA6841@filer
обсуждение исходный текст
Ответ на Re: LVM and Postgres  (Michael Stone <mstone+postgres@mathom.us>)
Список pgsql-performance
Michael Stone wrote:
> Note that the WAL will
> wander around the disk as files are created and deleted, whereas tables
> are basically updated in place.

Huh?  I was rather under the impression that the WAL files (in
pg_xlog, right?) were reused once they'd been created, so their
locations on the disk should remain the same, as should their data
blocks (roughly, depending on the implementation of the filesystem, of
course).


--
Kevin Brown                          kevin@sysexperts.com

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

Предыдущее
От: Edison Azzi
Дата:
Сообщение: Join the same row
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Query Fails with error calloc - Cannot alocate memory