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 or flat)
Thread:
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
negligible:

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)
{
	pgstat_report_tabstat();
	lasttme = currtme;
}

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

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

Responses

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-2014 The PostgreSQL Global Development Group