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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
