Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Query which "never" terminates - Mailing list pgsql-general

From pinker
Subject Re: [GENERAL] Query which "never" terminates
Date
Msg-id 1493301289569-5958736.post@n3.nabble.com
Whole thread Raw
In response to [GENERAL] Query which "never" terminates  (Viktor Fougstedt <viktor@chalmers.se>)
Responses Re: [GENERAL] Query which "never" terminates  (Viktor Fougstedt <viktor@chalmers.se>)
List pgsql-general
Tree view 
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 from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Viktor Fougstedt
Date:
Subject: [GENERAL] Query which "never" terminates
Next
From: Jan de Visser
Date:
Subject: Re: [GENERAL] Postgres connection Monitor