Postgres Pro
Downloads
Home   >   mailing lists

Re: checkpoint_segments - Mailing list pgsql-admin

From Tom Lane
Subject Re: checkpoint_segments
Date
Msg-id 1679.1141406271@sss.pgh.pa.us
Whole thread Raw
In response to checkpoint_segments  ("Mr. Dan" <bitsandbytes88@hotmail.com>)
List pgsql-admin
Tree view 
"Mr. Dan" <bitsandbytes88@hotmail.com> writes:
> I have checkpoint_segments set to 18, yet I have 38 segmnet files in
> pg_xlog.  Is there a reason for that?

The normal steady state is about 2N segment files, because we keep the
last two checkpoints' worth of WAL data.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Mr. Dan"
Date:
Subject: checkpoint_segments
Next
From: Simon Riggs
Date:
Subject: Re: PITR as Online Backup Solution