Re: [GENERAL] Large database

> > it would be nice if vacuum could figure out if an extent is no longer
> > in use, and delete it.
> >
> > currently, we need to dump the table, then nuke it and restore it.
>
> We tried removing the extra extent, but the other backends needed it
> around because there was no way to tell them that the extra extent file
> descriptor was useless.  You could just stop the postmaster, and delete
> the zero-length extents, if you really wanted to.  Do the extra extent
> files cause problems for you?  If so, we can start to look at some
> postmaster cleanup of those.

i haven't actually seen the system reduce a numbered extent.

i could be wrong.

--
[ Jim Mercer    Reptilian Research      jim@reptiles.org   +1 416 410-5633 ]
[ The telephone, for those of you who  have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail.            ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]