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

Re: Feature freeze date for 8.1

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Feature freeze date for 8.1
Date: 2005-04-29 22:15:18
Message-ID: m3ekctkz61.fsf@knuth.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Martha Stewart called it a Good Thing when scrappy(at)postgresql(dot)org ("Marc G. Fournier") wrote:
> I know one person was talking about being able to target only those
> that pages that have changes, instead of the whole table ... but some
> sort of "load monitoring" that checks # of active connections and
> tries to find 'lulls'?

I have some "log table purging" processes I'd like to put in place; it
would be really slick to be able to get some statistics from the
system as to how busy the DB has been in the last little while.  

The nice, adaptive algorithm:

- Loop forever

  - Once a minute, evaluate how busy things seem, giving some metric X

   -> If X is "high" then purge 10 elderly tuples from table log_table
   -> If X is "moderate" then purge 100 elderly tuples from table
      log_table
   -> If X is "low" then purge 1000 elderly tuples from table
      log_table

The trouble is in measuring some form of "X."

Some reasonable approximations might include:
 - How much disk I/O was recorded in the last 60 seconds?
 - How many application transactions (e.g. - invoices or such) were 
   issued in the last 60 seconds (monitoring a sequence could be
   good enough).
-- 
output = reverse("gro.mca" "@" "enworbbc")
http://linuxfinances.info/info/slony.html
?OM ERROR

In response to

Responses

pgsql-hackers by date

Next:From: Jim C. NasbyDate: 2005-04-29 23:39:44
Subject: Re: Feature freeze date for 8.1
Previous:From: Andrew DunstanDate: 2005-04-29 21:53:33
Subject: Re: [HACKERS] Increased company involvement

pgsql-patches by date

Next:From: Jim C. NasbyDate: 2005-04-29 23:39:44
Subject: Re: Feature freeze date for 8.1
Previous:From: Marc G. FournierDate: 2005-04-29 16:34:56
Subject: Re: Feature freeze date for 8.1

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