Re: pg_xlog content

From: Richard Huxton <dev(at)archonet(dot)com>
To: Siddharth Shah <siddharth(dot)shah(at)elitecore(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_xlog content
Date: 2008-12-02 12:00:47
Message-ID: 4935236F.60205@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ravi kiran 2008-12-02 12:05:35 Multi Lingual problem
Previous Message Richard Huxton 2008-12-02 11:59:36 Re: How to design for cheap reliability with PostgreSQL?