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

Re: keeping a timestamp of the last stats reset (for a db, table and function)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: keeping a timestamp of the last stats reset (for a db, table and function)
Date: 2010-12-23 19:09:13
Message-ID: AANLkTikXWxsfqOGHPqWann=kxWAmnREEUgnYP_P3Z-mp@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
2010/12/23 Tomas Vondra <tv(at)fuzzy(dot)cz>:
> Dne 20.12.2010 00:03, Tom Lane napsal(a):
>> 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
>>
>
> OK, so here goes the simplified patch - it tracks one reset timestamp
> for a background writer and for each database.

I think you forgot the attachment.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

pgsql-hackers by date

Next:From: Tomas VondraDate: 2010-12-23 19:39:40
Subject: Re: proposal : cross-column stats
Previous:From: Tomas VondraDate: 2010-12-23 17:47:53
Subject: Re: keeping a timestamp of the last stats reset (for a db, table and function)

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