Re: reducing statistics write overhead - Mailing list pgsql-hackers

From Tom Lane
Subject Re: reducing statistics write overhead
Date
Msg-id 7424.1220660677@sss.pgh.pa.us
Whole thread Raw
In response to Re: reducing statistics write overhead  (Euler Taveira de Oliveira <euler@timbira.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] "\ef " in psql
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: PostgreSQL SSL problem