Re: creating of temporary table takes very long - Mailing list pgsql-performance

From Tom Lane
Subject Re: creating of temporary table takes very long
Date
Msg-id 4409.1145302118@sss.pgh.pa.us
Whole thread Raw
In response to creating of temporary table takes very long  ("Sriram Dandapani" <sdandapani@counterpane.com>)
List pgsql-performance
"Sriram Dandapani" <sdandapani@counterpane.com> writes:
> [ query snipped ]
> This takes forever (I have to cancel the statement each time)

How long did you wait?

> c_chkpfw_hr_tr has same indexes as chkpfw_tr_hr_dimension

Which would be what exactly?  What does EXPLAIN show for that SELECT?
(I won't make you post EXPLAIN ANALYZE, if you haven't got the patience
to let it finish, but you should at least provide EXPLAIN results.)

            regards, tom lane

pgsql-performance by date:

Previous
From: "Sriram Dandapani"
Date:
Subject: Re: creating of temporary table takes very long
Next
From: "Sriram Dandapani"
Date:
Subject: Re: creating of temporary table takes very long