Re: pg_xlog content

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: pg_xlog content
Дата
Msg-id 4935236F.60205@archonet.com
обсуждение исходный текст
Ответ на Re: pg_xlog content  (Siddharth Shah <siddharth.shah@elitecore.com>)
Список pgsql-general
Siddharth Shah wrote:
>    I am not using wall based replication ? I no not have frequent & long
> transaction , need of checkpoints
> Just want to get what data resides in pg_xlog that it takes 16MB without
> any transactions.

The files are created 16MB long, it is faster to overwrite that than to
keep extending a shorter file. Since the WAL is written to with every
transaction it needs to be fast.

--
  Richard Huxton
  Archonet Ltd

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: How to design for cheap reliability with PostgreSQL?
Следующее
От: "ravi kiran"
Дата:
Сообщение: Multi Lingual problem