CODEWITHSUNDEEP
postgresql
Abhishek Parikh
Abhishek Parikh

Reputation: 181

how to turn off analyzer in postgresql

I would like to know from where can I turn off the analyzer in postgresql and what impact will it have on queries if they are plain simple queries (no joins nothing), simple group by , order by queries.

Upvotes: 0

Views: 1678

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 127056

The auto_vacuum proces also does the analyzing of your data. You could turn it off.

Another option could be to set default_statistics_target to 0, but in both cases the queryplanner won't have any usefull information about how to execute a query. Most indexes won't be used and if an index is used, it could use the wrong one.

Turning of the analyzer, makes the queryplanner blind and stupid. Most of your queries will suffer.

Upvotes: 3

Related Questions