Re: [GENERAL] after vacuum, db is still "growing" :(

2005-12-09 Thread Martijn van Oosterhout
On Fri, Dec 09, 2005 at 10:00:45AM +0100, Rafael Martinez Guerrero wrote: > On Fri, 2005-12-09 at 08:45, gabor wrote: > [...] > > > > are there any cases, where a normal vacuum is unable to reclaim some > > space > > Hello > > We have det same problem in some databases running 7.4.8. Hav

Re: [GENERAL] after vacuum, db is still "growing" :(

2005-12-09 Thread Rafael Martinez Guerrero
On Fri, 2005-12-09 at 08:45, gabor wrote: [...] > > are there any cases, where a normal vacuum is unable to reclaim some > space Hello We have det same problem in some databases running 7.4.8. Having max_fsm_pages and max_fsm_relations properly configurated does not help. It looks like

[GENERAL] after vacuum, db is still "growing" :(

2005-12-08 Thread gabor
hi, i'm using postgresql 7.4.8. we have a database that only contains one table that contains session data, so it changes very often. until now, we were vacuuming the database weekly. it's current size is 15GB. i know that when i once did a full-vacuum on this database, it's size shrunk to 1