Re: pg_xlog content - Mailing list pgsql-general

From Richard Huxton
Subject Re: pg_xlog content
Date
Msg-id 4935236F.60205@archonet.com
Whole thread Raw
In response to Re: pg_xlog content  (Siddharth Shah <siddharth.shah@elitecore.com>)
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: How to design for cheap reliability with PostgreSQL?
Next
From: "ravi kiran"
Date:
Subject: Multi Lingual problem