Re: reducing statistics write overhead
| От | Asko Oja |
|---|---|
| Тема | Re: reducing statistics write overhead |
| Дата | |
| Msg-id | ecd779860809060022ucfdef9dxe173339ec4b84d83@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: reducing statistics write overhead (Euler Taveira de Oliveira <euler@timbira.com>) |
| Список | pgsql-hackers |
On Sat, Sep 6, 2008 at 2:29 AM, Euler Taveira de Oliveira <euler@timbira.com> wrote:
Martin Pihlak escreveu:> I suspected that, but somehow managed to overlook it :( I guess it wasIf you can't afford a 500 msec pgstat time, then you need to make it
> too tempting to use it. I'll start looking for alternatives.
>
tunable.
Additional parameter in config file. Not good.
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.
Does not seem simple to me. Why would dba's want extra management work. We want all the stats to be there as we don't know when we need to look at it.
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления: