Re: reducing statistics write overhead

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: reducing statistics write overhead
Дата
Msg-id 7424.1220660677@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: reducing statistics write overhead  (Euler Taveira de Oliveira <euler@timbira.com>)
Список pgsql-hackers
Euler Taveira de Oliveira <euler@timbira.com> writes:
> 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.

For normal usage on-demand dumping would be a really good thing; it'd
cut the overhead of having stats on tremendously, especially for people
who don't really use 'em.  The particular signaling proposed here is
bogus, but if Martin can make it work in a cleaner fashion I think it's
likely a good idea.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] "\ef " in psql
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: PostgreSQL SSL problem