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

From Euler Taveira de Oliveira
Subject Re: reducing statistics write overhead
Date
Msg-id 48C1C0EE.9050702@timbira.com
Whole thread Raw
In response to Re: reducing statistics write overhead  (Martin Pihlak <martin.pihlak@gmail.com>)
Responses Re: reducing statistics write overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: reducing statistics write overhead  ("Asko Oja" <ascoja@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Need more reviewers!
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] "\ef " in psql