Re: Reducing stats collection overhead - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Reducing stats collection overhead
Date
Msg-id 200704291008.l3TA8JT27139@momjian.us
Whole thread Raw
In response to Re: Reducing stats collection overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Yes, it seems we will have to do something for 8.3.
> 
> Yeah, we've kind of ignored any possible overhead of the stats mechanism
> for awhile, but I think we've got to face up to this if we're gonna have
> it on by default.
> 
> > I assume the method
> > below would reduce frequent updates of the stats_command_string too.
> 
> No, stats_command_string is entirely independent now.

Oh, right, we used shared memory.  No wonder it isn't on the TODO list
anymore.  ;-)

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reducing stats collection overhead
Next
From: Martijn van Oosterhout
Date:
Subject: Re: question for serial types with CHECK conditions