Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Reducing stats collection overhead


  • From: Bruce Momjian <bruce(at)momjian(dot)us>
  • To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • Cc: pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: Reducing stats collection overhead
  • Date: Sun, 29 Apr 2007 06:08:18 -0400 (EDT)
  • Message-id: <200704291008.l3TA8JT27139@momjian.us> <text/plain>

Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)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(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group