Maintenance_work_mem influence on queries

Поиск
Список
Период
Сортировка
От luchot
Тема Maintenance_work_mem influence on queries
Дата
Msg-id 14743652.1144313861246.JavaMail.www@wwinf4101
обсуждение исходный текст
Список pgsql-performance

Hello,

I am doing some test with differents values for the parameter maintenance_work_mem in order to

ameliorate the time for the creation of index and and the use of vacuum and analyse.

I read in the doc that this parameter is just for create index, vacuum and analyse and foreign key .

But when i test 2 queries with differents values the result are twice big :

for mwm to 64 Mo   the query 1 last 34 min and the query 2   41 min

for mwm to 512 mo the query 1 last 17 min and the query 2 21 min

So my question is in what condition the parameter maintenance_work_mem influence on the execution of queries. 

  Thanks ,

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

Предыдущее
От: Ragnar
Дата:
Сообщение: Re: Query planner is using wrong index.
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: Sun Fire T2000 and PostgreSQL 8.1.3