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

Row level stats

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Row level stats
Date: 2003-03-06 05:29:13
Message-ID: 1046928553.32534.27.camel@jester (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
It would be nice if PGAvd could receive row level stats without a large
hit to simple queries.

Ran a simple test.  Calling pgstat_report_tabstat() at a frequency of
once per second reduces the time taken for row level stats to be

500k select TRUE statements took:
6:50 with stats off
8:35 with row level stats on
6:52 with the below applied and row level stats on

Anyone object to delaying the submission of stats by that timeframe? 
Are row level stats enough for PGAvd?

More or less the below for the change on line 1912 in postgres.c

currtme = GetCurrentAbsoluteTime();
if (lasttme < currtme)
	lasttme = currtme;

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

PGP Key:


pgsql-hackers by date

Next:From: Joe ConwayDate: 2003-03-06 05:32:01
Subject: Re: [HACKERS] problems with dropped columns
Previous:From: Joe ConwayDate: 2003-03-06 05:20:21
Subject: Re: [HACKERS] problems with dropped columns

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