Enabling and disabling run time configuration parameters.
От | Yusuf |
---|---|
Тема | Enabling and disabling run time configuration parameters. |
Дата | |
Msg-id | 3EDF633A.8000502@netscape.net обсуждение исходный текст |
Ответы |
Re: Enabling and disabling run time configuration parameters.
Re: Enabling and disabling run time configuration parameters. Re: Enabling and disabling run time configuration parameters. Re: Enabling and disabling run time configuration parameters. Re: Enabling and disabling run time configuration parameters. |
Список | pgsql-performance |
I have discovered that I could optimize queries by adjusting the following parameters such as enable_seqscan, enable_hashjoin, enable_mergejoin and enable_nestloop. Is it a good idea, to temporarily adjust those values before running a query to spend up the execution time? I've searched online and wasn't able to find articles about it. I need to speed up an enterprise application that I'm working on, and I wouldn't want to screw things up. My plan is for every query that could be optimized by adjusting parameters: I'll enable parameters that'll speed it up, run the query, then set the parameters back to their default values. Thanks in advance.
В списке pgsql-performance по дате отправления: