Re: Vacuum full

Thanks

I think that is what I wanted to hear.

Regarding the version we are running. The last upgrade I did from 7.1 to
7.2.1 took several months. The main problem was not the change in the
semantics of the syntax, but the performance blow out we experienced. Once
I had re-written the offending code, several weeks of regression testing had
to be done. I will look at the link you sent me regarding the 7.2/3 news,
to see if there are any bugs that could be a potential problem for us.

Thanks again for your time

Andrew Bartley

----- Original Message -----
From: "Justin Clift" <justin(at)postgresql(dot)org>
To: "Andrew Bartley" <abartley(at)evolvosystems(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, November 06, 2002 2:36 PM
Subject: Re: [GENERAL] Vacuum full

> Andrew Bartley wrote:
> >
> > Thanks Justin,
> >
> > I suppose the reason for the question is related to the limit on the
number
> > trans before there is a problem.
>
> No stress. One of the developers will be able to answer you in regards
> to this. :) If no-one pipes up and says anything, then it's worth
> asking on the PostgreSQL Hackers mailing list
> (pgsql-hackers(at)postgresql(dot)org).
>
> > Regarding the static type app tables I keep referring to. These tables
are
> > period based. i.e. At the end of the period these tables are loaded and
> > vacuumed, then used for reporting purposes only. In the next/new period
a
> > new table will be created added to/updated, then closed at the end of
the
> > period. The tables are dynamically accessed using "execute" based on
the
> > period selected in the report criteria requested by the user from the
GUI.
> >
> > The tables in question will never change from the point when the period
is
> > closed.
>
> Ok, after they're loaded it's worth doing an ANALYZE to ensure the
> planner statistics and similar are updated and made accurate. After
> that though, as they're totally static you'd be wasting your time
> running VACUUM or any further ANALYZE's on them.
>
>
> > Thanks for your help and info.
>
> That's cool. :)
>
> Regards and best wishes,
>
> Justin Clift
>
> > Andrew
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
>
>