Hello,
and thanks for your reply.
SET from_collapse_limit=1;
did no difference, I’m afraid.
I ran both VACUUM and ANALYZE before I posted, and there was no noticable
difference from either of them.
Regards,
/Viktor
> On 27 apr 2017, at 15:54, pinker wrote:
>
> Try to change from_collaps
Try to change from_collapse_limit values at first, for instance run SET
from_collapse_limit = 1; and then your query in the same session.
have you ran analyze lately?
--
View this message in context:
http://www.postgresql-archive.org/Query-which-never-terminates-tp5958734p5958736.html
Sent fr
Dear sirs.
I have an issue which I am at a loss to solve. Because of the behaviour I am
not certain that this is a “slow query” problem, so I send my question here.
My question regards a query using deep subqueries. EXPLAIN gives a maximum cost
of about 2.000 (details below), but the query runs
