Changing tuning parameters with EXPLAIN

Поиск
Список
Период
Сортировка
От Antonio Carlos Salzvedel Furtado Junior
Тема Changing tuning parameters with EXPLAIN
Дата
Msg-id CAERqmVorUFACg8YKiVQevyeupZVZfHb6va-Fyy+NwDDu_7-tRA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Changing tuning parameters with EXPLAIN  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-novice
Hello PostgreSQL users,

I've been working with the estimated cost from EXPLAIN. I was wondering if  I could change the tuning parameters, to produce new estimated costs, without interfering with the database workload. Is it possible?

I'm changing these parameters by executing SQL queries ("SET"). The problem is that once I change these parameters, the query optimizer will start using these values to build their query plans.

Cordially,

Antonio Carlos Furtado

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Van Orden, Brad"
Дата:
Сообщение: Re: database in different location owned by different user
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Changing tuning parameters with EXPLAIN