Re: after vacuum, db is still "growing" :(

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 this happens in tables with data that is updated/deleted
very often and that the files growing are the ones for the indexes, when
using B-trees.

We noticed this problem when a clean restore of a database used much
less space and the big different were in the indexes files.

In a busy 24/7 database a reindex of the indexes in a big table is not
a solution because using an ACCESS EXCLUSIVE lock for a 'long' time will
block access to data.

I have not tested if the only problem is that we use more and more space
or if performance also gets worst.

Is it possible to fix this, do we have any plans, is it better with 8.0
or 8.1?

Thanks in advance for your answers :)
--
Rafael Martinez, <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Center for Information Technology Services
University of Oslo, Norway

PGP Public Key: http://folk.uio.no/rafael/