Skip site navigation (1) Skip section navigation (2)

Re: BUG #2259: never ending select from selects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michal Dvoracek" <michal(dot)dvoracek(at)capitol(dot)cz>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2259: never ending select from selects
Date: 2006-02-15 18:29:20
Message-ID: 14974.1140028160@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Michal Dvoracek" <michal(dot)dvoracek(at)capitol(dot)cz> writes:
> this query runs very long time - after hour i cancelled it.

The EXPLAIN output is just about unreadable as you've posted it ---
could you fix that and repost?  Also please provide EXPLAIN ANALYZE
output for all the cases that do finish in a reasonable amount of 
time, especially the one where you made temporary tables.  Also,
what are the table schemas (particularly, what indexes do they have)?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Stephen FrostDate: 2006-02-15 18:32:09
Subject: BUG #2246: Only call pg_fe_getauthname if none given
Previous:From: Tom LaneDate: 2006-02-15 18:21:48
Subject: Re: BUG #2260: PGCrypto Memory Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group