Re: keeping a timestamp of the last stats reset (for a db, table and function) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: keeping a timestamp of the last stats reset (for a db, table and function)
Date
Msg-id 17858.1292799810@sss.pgh.pa.us
Whole thread Raw
In response to Re: keeping a timestamp of the last stats reset (for a db, table and function)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: keeping a timestamp of the last stats reset (for a db, table and function)  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-hackers
I wrote:
> That is not the number of interest.  The number of interest is that it's
> 8 bytes added onto a struct that currently contains 11 of 'em; in other
> words a 9% increase in the size of the stats file, and consequently
> about a 9% increase in the cost of updating it.

Wups, sorry, I was looking at the wrong struct.  It's actually an
addition of 1 doubleword to a struct of 21 of 'em, or about 5%.
That's still an awful lot in comparison to the prospective usefulness
of the information.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: keeping a timestamp of the last stats reset (for a db, table and function)
Next
From: Itagaki Takahiro
Date:
Subject: Re: Extensions, patch v20 (bitrot fixes)