X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 579BDD1CB1D for ; Sun, 8 Feb 2004 05:36:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 52065-04 for ; Sun, 8 Feb 2004 01:36:22 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 68808D1C98E for ; Sun, 8 Feb 2004 01:36:21 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id EC81035554; Sat, 7 Feb 2004 21:36:20 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id EB0E835337; Sat, 7 Feb 2004 21:36:20 -0800 (PST) Date: Sat, 7 Feb 2004 21:36:20 -0800 (PST) From: Stephan Szabo To: Bruno BAGUETTE Cc: pgsql-performance@postgresql.org Subject: Re: RE : RE : Increase performance of a UNION query that In-Reply-To: Message-ID: <20040207213513.A41594@megazone.bigpanda.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/113 X-Sequence-Number: 5637 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.