Pavel,
> 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.
I'm not comfortable with increasing the default, yet. While folks on dedicated good hardware can handle a collapse of
10-12joins, a lot of people are running PostgreSQL on VMs these days whose real CPU power is no better than a Pentium
IV. Also, if you're doing OLTP queries on small tables, spending 20ms planning a query is unreasonably slow in a way it
isnot for a DW query.
It does make a reasonable piece of advice for those tuning for DW, though. I'll add it to my list.
Speaking of which, what happened to replacing GEQO with Simulated Annealing? Where did that project go?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
San Francisco