CODEWITHSUNDEEP
postgresqlquery-optimization
user3419945
user3419945

Reputation: 367

How to disable/enable different query optimizations in POSTGRESQL?

I'm doing some test to see the capability of Postgresql query performance. And my plan is to disable/enable different query optimizations, such as disable (automatic) index, disable re-order joins etc. is there some configuration to achieve this quickly or what part source code should I revise? thanks.

Upvotes: 0

Views: 221

Answers (1)

Craig Ringer
Craig Ringer

Reputation: 324901

PostgreSQL provides debug parameters for exactly this.

See the enable_ params in the docs.

Please don't use them in production; it might seem like a good idea at the time, but those settings won't adapt as the data changes and grows, so what starts out as a performance win will probably become a problem later.

Upvotes: 1

Related Questions