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
Дата:
Сообщение: Re: Degrading performance
От: scott.marlowe
Дата:
FAQ