From: Tom Lane <tgl@sss.pgh.pa.us>
To: Charles Hauser <chauser@duke.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: query optimization
Date: Thu, 04 Mar 2004 16:15:50 -0500
Message-ID: <28774.1078434950@sss.pgh.pa.us> (raw)
In-Reply-To: <1078422984.5001.18.camel@pandorina>
References: <1078422984.5001.18.camel@pandorina>
Charles Hauser <chauser@duke.edu> writes:
> I have the following query which is running quite slow on our server and
> was hoping someone would have suggestions how I might improve it.
Have you vacuumed or analyzed these tables recently? The EXPLAIN
numbers show that the planner thinks all the tables are tiny, which
hardly seems likely given that you're complaining about the speed.
If it's still bad after you VACUUM ANALYZE, send EXPLAIN ANALYZE (not
just EXPLAIN) output and maybe we can give some help.
regards, tom lane
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-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, chauser@duke.edu
Subject: Re: query optimization
In-Reply-To: <28774.1078434950@sss.pgh.pa.us>
* 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