"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 Frost||Date: 2006-02-15 18:32:09|
|Subject: BUG #2246: Only call pg_fe_getauthname if none given|
|Previous:||From: Tom Lane||Date: 2006-02-15 18:21:48|
|Subject: Re: BUG #2260: PGCrypto Memory Problem |