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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2003-03-06 05:32:01 | Re: [HACKERS] problems with dropped columns |
Previous Message | Joe Conway | 2003-03-06 05:20:21 | Re: [HACKERS] problems with dropped columns |