Hello

Actually we had to solve a issue with slow SELECT. The problem was in
low value of JOIN_COLLAPSE_LIMITS. Can we increase a default of this
value. I checked some complex query, and planner needed about 200ms
for JOIN_COLLAPSE_LIMIT = 16. So some around 12 can be well.

Regards

Pavel Stehule

Responses

• Re: increasing collapse_limits? at 2011-04-30 17:38:38 from Tom Lane
• Re: increasing collapse_limits? at 2011-05-01 19:16:40 from Joshua Berkus

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2011-04-30 16:25:56
	Subject: Re: Feature proposal: distinguish each PostgreSQL instance in the event log
Previous:	From: Peter Eisentraut	Date: 2011-04-30 14:59:32
	Subject: Re: Changing the continuation-line prompt in psql?