Re: checkpoint_segments

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mr(dot) Dan" <bitsandbytes88(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: checkpoint_segments
Date: 2006-03-03 17:17:51
Message-ID: 1679.1141406271@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Mr. Dan" <bitsandbytes88(at)hotmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2006-03-03 17:54:52 Re: PITR as Online Backup Solution
Previous Message Mr. Dan 2006-03-03 16:31:51 checkpoint_segments