Re: Very long VACUUM time ...

Depends on alot of things ... big one is when was the last vacuum and how
much has been DELETEd/UPDATEd since then?

I have one client that has a nice simple table with something like 5
records in it ... it gets UPDATEd soooooo much that the table grows from
~8k to 64Meg in a matter of hours ... if I vacuum every 2hrs, it takes
alot less time then, say, ever 6hrs, since its got less changes to deal
with cleaing out ...

On Sat, 28 Apr 2001, Feite Brekeveld wrote:

> Hi,
>
> I have running a SPARC Ultra-60 with a database with 2 tables containing
> 2.2 mln records. What is a normal time to run a vacuum on this.
>
> Each table has 4 indexes of which one is a composite index of 4
> attributes.
>
> Thanks,
>
>
> Feite Brekeveld
> feite.brekeveld@osiris-it.nl
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org