Postgres Pro
Downloads
Home   >   mailing lists

Re: Can you help with this JOIN? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Can you help with this JOIN?
Date
Msg-id 24119.1022690226@sss.pgh.pa.us
Whole thread Raw
In response to Can you help with this JOIN?  (Wei Weng <wweng@kencast.com>)
Responses Re: Can you help with this JOIN?  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
Tree view 
Wei Weng <wweng@kencast.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

pgsql-sql by date:

Previous
From: Wei Weng
Date:
Subject: Re: Can you help with this JOIN?
Next
From: achill@matrix.gatewaynet.com
Date:
Subject: contrib/tree issues