Re: check point segments leakage ?

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073