Enabling and disabling run time configuration parameters.
От
Yusuf
Тема
Enabling and disabling run time configuration parameters.
Дата
Msg-id
3EDF633A.8000502@netscape.net
Список
Дерево обсуждения
Enabling and disabling run time configuration parameters. Yusuf <yusuf0478@netscape.net>
Re: Enabling and disabling run time configuration parameters. Rod Taylor <rbt@rbt.ca>
Re: Enabling and disabling run time configuration parameters. Josh Berkus <josh@agliodbs.com>
Re: Enabling and disabling run time configuration parameters. Bruno Wolff III <bruno@wolff.to>
Re: Enabling and disabling run time configuration parameters. Andrew Sullivan <andrew@libertyrms.info>
Re: Enabling and disabling run time configuration parameters. "scott.marlowe" <scott.marlowe@ihs.com>
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 по дате отправления
От: scott.marlowe
Дата: