By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,353 Members | 1,235 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,353 IT Pros & Developers. It's quick & easy.

Planner configuration

P: n/a
I was reading the section about Planner Method Configuration, and I just don't
get why all the options have this message: "This is used for debugging the
query planner". Are they all debugging options, because they don't look like.

http://www.postgresql.org/docs/current/interactive/
-> runtime-config.html#RUNTIME-CONFIG-QUERY

--
15:45:02 up 64 days, 22:01, 2 users, load average: 1.49, 1.32, 0.85
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Martin Marques <ma****@bugs.unl.edu.ar> writes:
I was reading the section about Planner Method Configuration, and I just don't
get why all the options have this message: "This is used for debugging the
query planner". Are they all debugging options, because they don't look like.


The enable_xxx options are debugging options in the sense that they're
not meant to be used in routine operations. They are intended to make
it possible to experiment with alternative plan choices --- but ideally
you should be able to get the planner to pick a good plan choice of its
own accord. You may need to tweak the cost parameters to reflect your
platform more accurately, or you may need to tune some other settings,
or gather more complete data statistics. If none of this helps it's
grounds for a bug report.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.