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-11 14:21:43
Message-ID: 22592.1157984503@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:
> here is the output of the explain query after changing the tra_date column to timestamp.

If you want intelligent commentary, please (a) post EXPLAIN ANALYZE not
EXPLAIN output, and (b) don't mangle the indentation. This is just
about unreadable :-(

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-09-11 14:28:51 Re: Abysmal hash join
Previous Message Florian Weimer 2006-09-11 13:48:03 Abysmal hash join