Re: reducing statistics write overhead

Поиск
Список
Период
Сортировка
От Euler Taveira de Oliveira
Тема Re: reducing statistics write overhead
Дата
Msg-id 48C1C0EE.9050702@timbira.com
обсуждение исходный текст
Ответ на Re: reducing statistics write overhead  (Martin Pihlak <martin.pihlak@gmail.com>)
Ответы Re: reducing statistics write overhead
Re: reducing statistics write overhead
Список pgsql-hackers
Martin Pihlak escreveu:
> I suspected that, but somehow managed to overlook it :( I guess it was
> too tempting to use it. I'll start looking for alternatives.
> 
If you can't afford a 500 msec pgstat time, then you need to make it
tunable. Another ideas are (i) turn on/off pgstat per table or database
and (ii) make the pgstat time tunable per table or database. You can use
the reloptions column to store these info. These workarounds are much
simpler than that you proposed and they're almost for free.


--  Euler Taveira de Oliveira http://www.timbira.com/


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Need more reviewers!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] "\ef " in psql