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

Re: Row level stats

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Row level stats
Date: 2003-03-06 14:16:24
Message-ID: 1046960184.337.5.camel@jester (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, 2003-03-06 at 01:13, Tom Lane wrote:
> Rod Taylor <rbt(at)rbt(dot)ca> writes:
> > [ optimizing for small frequent queries ]
> 
> What if the client doesn't come back with another query for awhile?

Yup.. Thats why I said you basically lose 1 seconds worth of stats (or
rather can't count on when they arrive).

But, that doesn't matter for most cases as you cannot cause a lot of
trouble with 1 seconds worth of activity.  That said, I'd make the
actual value a GUC.

However, having the numbers off by a little (the %age they're off by
decreases with increased activity) is still a lot more useful than not
having any numbers at all.


Anyway, the basic proposal would be to change the on / off flags for row
& block level into a 'stats delay'.  A large number would be off, 0
would have the same properties as today.  Default to be determined (but
1 second seems to be plenty).

-- 
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Responses

pgsql-hackers by date

Next:From: Dave PageDate: 2003-03-06 14:54:25
Subject: Re: Win32 Powerfail testing
Previous:From: Justin CliftDate: 2003-03-06 14:11:23
Subject: Re: Who puts the Windows binaries on the FTP server?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group