Gaetano Mendola wrote:
> Bruce Momjian wrote:
>
> > Scott Marlowe wrote:
> >
> >>>>I use a checkpoint_segments = 16 but in my pg_xlog I have
> >>>>35 files. Why 35 files ?
> >
> >
> > You have 35 because the max files in pg_xlog is 2*checkpoint_segments +1
> > or something like that. This is documented in the SGML.
>
> Ok, that explain why. And they will remain there also if not needed ?
Yes, it keeps them around so it doesn't need to recreate them.
> Another weird behaviour is that during the day the storage space usage
> increase gruadualy. Since today as the graph show the space usage
> is constant, it's like if some space was pre-allocated and now is
> used, see same yesterday period between 18:00 and 24:00.
> Toughts ?
My guess is that you need a certain amount of free space in the tables
to operate properly.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073