Re: Vacuum full - Mailing list pgsql-general

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@postgresql.org>
To: "Andrew Bartley" <abartley@evolvosystems.com>
Cc: <pgsql-general@postgresql.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@postgresql.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
>
>