Re: turning of pg_xlog - Mailing list pgsql-admin

From Tom Lane
Subject Re: turning of pg_xlog
Date
Msg-id 23386.1222800278@sss.pgh.pa.us
Whole thread Raw
In response to Re: turning of pg_xlog  (Chander Ganesan <chander@otg-nc.com>)
Responses Re: turning of pg_xlog  (Chander Ganesan <chander@otg-nc.com>)
Re: turning of pg_xlog  ("Plugge, Joe R." <JRPlugge@west.com>)
List pgsql-admin
Chander Ganesan <chander@otg-nc.com> writes:
> You should also understand that if you set checkpoint_segments to a
> small number, its still possible that PostgreSQL might use more than
> that number for a large transaction.

"Large transactions" have nothing to do with this.  You are confusing
Postgres' implementation with Oracle's.

            regards, tom lane

pgsql-admin by date:

Previous
From: Chander Ganesan
Date:
Subject: Re: turning of pg_xlog
Next
From: Chander Ganesan
Date:
Subject: Re: turning of pg_xlog