Re: Hash join on int takes 8..114 seconds

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: Hash join on int takes 8..114 seconds
Дата
Msg-id A44943E272DF48CC9BC306C513387020@andrusnotebook
обсуждение исходный текст
Ответ на Re: Hash join on int takes 8..114 seconds  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Hash join on int takes 8..114 seconds  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Hash join on int takes 8..114 seconds  (Tomas Vondra <tv@fuzzy.cz>)
Список pgsql-performance
Alvaro,

> Are you really using vacuum_cost_delay=2000?  If so, therein lies your
> problem.  That's a silly value to use for that variable.  Useful values
> are in the 20-40 range probably, or maybe 10-100 being extremely
> generous.

Thank you.
My 8.1.4 postgresql.conf does not contain such option. So vacuum_cost_delay
is off probably.
Since doc does not recommend any value, I planned to use 2000

Will value of 30 allow other clients to work when VACUUM FULL is running ?

Uncommented relevant values in postgresql.conf file are:

shared_buffers = 15000
work_mem = 512
maintenance_work_mem = 131072
fsync = on
effective_cache_size= 70000
log_min_duration_statement= 30000

Andrus.


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Hash join on int takes 8..114 seconds
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Hash join on int takes 8..114 seconds