From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Bruno BAGUETTE <pgsql-ml@baguette.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: RE : RE : Increase performance of a UNION query that
Date: Sat, 7 Feb 2004 21:36:20 -0800 (PST)
Message-ID: <20040207213513.A41594@megazone.bigpanda.com> (raw)
In-Reply-To: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAeVfx9WlOXEyeDyg88U7qaAEAAAAA@baguette.net>
References: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAeVfx9WlOXEyeDyg88U7qaAEAAAAA@baguette.net>
On Sun, 8 Feb 2004, Bruno BAGUETTE wrote:
> > On Fri, 6 Feb 2004, Bruno BAGUETTE wrote:
> >
> > > > In addition to what Tom said, the row estimates look suspiciously
> > > > default. You mention vacuuming, but do you ever analyze
> > > > the tables?
> > >
> > > I run VACUUM FULL ANALYZE with the postgres user on all the
> > > PostgreSQL
> > > databases on the server, twice a day, sometimes more.
> >
> > Wierd, because you're getting 1000 estimated on both people
> > and organizations. What does pg_class have to say about
> > those two tables?
>
> I'm sorry but I think that I misunderstand you. Are you telling me that
> running VACUUM FULL ANALYZE is weird ? Or do you mean another thing ?
No, I was saying it's wierd that it'd be misestimating to the default
values after a vacuum full analyze.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sszabo@megazone.bigpanda.com, pgsql-ml@baguette.net
Subject: Re: RE : RE : Increase performance of a UNION query that
In-Reply-To: <20040207213513.A41594@megazone.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox