Re: Performance problem with joins

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: fardeen memon <frank69in(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problem with joins
Date: 2006-09-08 14:46:16
Message-ID: 8114.1157726776@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

fardeen memon <frank69in(at)yahoo(dot)com> writes:
> What is it that i am doing wrong?

I think the forced coercion to date type in the view case is preventing
the planner from making a good guess about the selectivity of the
condition on tra_date. It has stats about tra_date's distribution,
but none about the distribution of "tra_date::date".

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Phadnis 2006-09-08 14:49:32 unsubscribe me
Previous Message Dave Cramer 2006-09-08 13:01:57 Re: Xeon Woodcrest/Dempsey vs Opteron Socket F/940 with postgresql and some SAS raid-figures