Re: Can you help with this JOIN?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wei Weng <wweng(at)kencast(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Can you help with this JOIN?
Date: 2002-05-29 16:37:06
Message-ID: 24119.1022690226@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Wei Weng <wweng(at)kencast(dot)com> writes:
> I have a massive join that takes something like 10 seconds to execute in
> Postgresql 7.2. Can any of gurus here help me improve it?

1. Have you vacuum analyzed these tables lately? The row count
estimates look suspiciously low.

2. Please provide EXPLAIN ANALYZE output not just EXPLAIN.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-05-29 17:18:52 Re: Can you help with this JOIN?
Previous Message achill 2002-05-29 16:35:06 contrib/tree issues