Postgres Pro
Downloads
Home   >   mailing lists

increasing collapse_limits? - Mailing list pgsql-hackers

From Pavel Stehule
Subject increasing collapse_limits?
Date
Msg-id BANLkTin4ncKMg+bEixi1WB1RJPrZ5dVRgQ@mail.gmail.com
Whole thread Raw
Responses Re: increasing collapse_limits?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: increasing collapse_limits?  (Joshua Berkus <josh@agliodbs.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Changing the continuation-line prompt in psql?
Next
From: Bruce Momjian
Date:
Subject: Re: Feature proposal: distinguish each PostgreSQL instance in the event log