pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.



view thread (2+ messages)

Message-ID: <20040207213513.A41594@megazone.bigpanda.com>
Permalink:  ../20040207213513.A41594@megazone.bigpanda.com/
Also on:    postgresql.org/message-id/20040207213513.A41594@megazone.bigpanda.com

 · 

reply

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