Re: Vacuuming - how often?

Hello,

An active database, should be vacummed nightly. It will keep things in tip
top shape and help maintain the database overall.

J

On Tue, 13 Nov 2001, Scott Muir wrote:

> I'm using 7.1 on redhat 7.1...
>
> I had a query result which startled me a bit... it was a simple join and
> the result was like a cartesian product like I hadn't bothered with a when
> clause.
>
> I ran vacuum from inside pgaccess and the results of the query changed to
> what I was expecting in the first place...
>
> What I'm wondering is what is the likely problem here? Does this mean that
> *regular* maintenance is required? the data in this database is pretty much
> append only.. with some updating, but next to zero deleting is done...
>
> any comments on this?
>
> thanks
> Scott.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
--
by way of pgsql-general(at)commandprompt(dot)com
http://www.postgresql.info/
http://www.commandprompt.com/