Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding nextval() to a select caused hang/very slow execution - Mailing list pgsql-performance

From Tom Lane
Subject Re: Adding nextval() to a select caused hang/very slow execution
Date
Msg-id 1238445.1604518544@sss.pgh.pa.us
Whole thread Raw
In response to Re: Adding nextval() to a select caused hang/very slow execution  (Eric Raskin <eraskin@paslists.com>)
List pgsql-performance
Tree view 
... btw, it occurs to me that at least as a stopgap,
"set enable_nestloop = off" would be worth trying.
The killer problem with rowcount-1 estimates is that they
encourage the planner to use nestloops when it shouldn't.

            regards, tom lane

pgsql-performance by date:

Previous
From: Eric Raskin
Date:
Subject: Re: Adding nextval() to a select caused hang/very slow execution
Next
From: David Rowley
Date:
Subject: Re: Partition pruning with joins