Re: query optimization

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Charles Hauser <chauser(at)duke(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: query optimization
Date: 2004-03-04 21:15:50
Message-ID: 28774.1078434950@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Charles Hauser <chauser(at)duke(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-03-04 21:35:01 Re: debugging query to put message in pg logfile?
Previous Message Radu-Adrian Popescu 2004-03-04 21:01:47 Re: returning a recordset from PLpg/SQL