Re: Feature freeze date for 8.1

От: Marc G. Fournier
Тема: Re: Feature freeze date for 8.1
Дата: ,
Msg-id: 20050429225626.X53065@ganymede.hub.org
(см: обсуждение, исходный текст)
Ответ на: Re: Feature freeze date for 8.1  (Christopher Browne)
Ответы: Re: Feature freeze date for 8.1  ("Matthew T. O'Connor")
Список: pgsql-hackers

Скрыть дерево обсуждения

Feature freeze date for 8.1  (Bruce Momjian, )
 Re: Feature freeze date for 8.1  (Bruno Wolff III, )
 Re: Feature freeze date for 8.1  (Rob Butler, )
 Re: Feature freeze date for 8.1  (Andreas Pflug, )
 Re: Feature freeze date for 8.1  (Christopher Browne, )
  Re: Feature freeze date for 8.1  (Tom Lane, )
   Re: Feature freeze date for 8.1  (Bruce Momjian, )
    Re: Feature freeze date for 8.1  (Bruno Wolff III, )
     Re: Feature freeze date for 8.1  ("Marc G. Fournier", )
      Re: Feature freeze date for 8.1  (Bruno Wolff III, )
   Re: Feature freeze date for 8.1  ("Matthew T. O'Connor", )
    Re: Feature freeze date for 8.1  (Tom Lane, )
     Re: Feature freeze date for 8.1  ("Marc G. Fournier", )
      Re: Feature freeze date for 8.1  ("Jim C. Nasby", )
 Re: Feature freeze date for 8.1  (Christopher Browne, )
  Re: Feature freeze date for 8.1  ("Marc G. Fournier", )
   Re: Feature freeze date for 8.1  ("Matthew T. O'Connor", )
 Re: Feature freeze date for 8.1  ("Sander Steffann", )
  Re: Feature freeze date for 8.1  (<>, )
   Re: Feature freeze date for 8.1  (Alvaro Herrera, )
    Re: Feature freeze date for 8.1  (Peter Eisentraut, )
     Re: Feature freeze date for 8.1  (Tom Lane, )
      Re: Feature freeze date for 8.1  (<>, )
       Re: Feature freeze date for 8.1  (Bruno Wolff III, )
        Re: Feature freeze date for 8.1  (<>, )
         Re: Feature freeze date for 8.1  (Jaime Casanova, )
          Re: Feature freeze date for 8.1  (Tom Lane, )
           Re: Feature freeze date for 8.1  (Oliver Jowett, )
            Re: Feature freeze date for 8.1  (Tom Lane, )
             Re: Feature freeze date for 8.1  (Oliver Jowett, )
           Re: Feature freeze date for 8.1  (<>, )
          Re: Feature freeze date for 8.1  (<>, )
       Re: Feature freeze date for 8.1  (Neil Conway, )
        Re: Feature freeze date for 8.1  (Oliver Jowett, )
         Re: Feature freeze date for 8.1  (Neil Conway, )
          Re: Feature freeze date for 8.1  (Tom Lane, )
           Re: Feature freeze date for 8.1  (Neil Conway, )
            Re: Feature freeze date for 8.1  (Russell Smith, )
             Re: Feature freeze date for 8.1  (Tom Lane, )
            Re: Feature freeze date for 8.1  (Tom Lane, )
             Re: Feature freeze date for 8.1  (Neil Conway, )
              Re: Feature freeze date for 8.1  (Oliver Jowett, )
              Re: Feature freeze date for 8.1  (<>, )
             Re: Feature freeze date for 8.1  (Dennis Bjorklund, )
              Re: Feature freeze date for 8.1  (Alvar Freude, )
               Re: Feature freeze date for 8.1  (<>, )
             Re: Feature freeze date for 8.1  (<>, )
             Re: Feature freeze date for 8.1  (Hannu Krosing, )
              Re: Feature freeze date for 8.1  (<>, )
              Re: Feature freeze date for 8.1  (Heikki Linnakangas, )
               Re: Feature freeze date for 8.1  (<>, )
               Re: Feature freeze date for 8.1  (Dawid Kuroczko, )
               Re: Feature freeze date for 8.1  (Hannu Krosing, )
                Re: Feature freeze date for 8.1  (Tom Lane, )
                 Re: Feature freeze date for 8.1  (Heikki Linnakangas, )
                  Re: Feature freeze date for 8.1  (Tom Lane, )
            Re: Feature freeze date for 8.1  (Peter Eisentraut, )
             Re: Feature freeze date for 8.1  (Oliver Jowett, )
              Re: Feature freeze date for 8.1  (Tom Lane, )
               Re: Feature freeze date for 8.1  (Oliver Jowett, )
               Re: Feature freeze date for 8.1  (Oliver Jowett, )
             Re: Feature freeze date for 8.1  (<>, )
             Re: Feature freeze date for 8.1  (Tom Lane, )
        Re: Feature freeze date for 8.1  (<>, )
      Re: Feature freeze date for 8.1  (Hannu Krosing, )
       Re: Feature freeze date for 8.1  (<>, )
    Re: Feature freeze date for 8.1  (Dennis Bjorklund, )
 Re: Feature freeze date for 8.1  (<>, )
  Re: Feature freeze date for 8.1  (Dennis Bjorklund, )
   Re: Feature freeze date for 8.1  (<>, )
  Re: Feature freeze date for 8.1  (Christopher Kings-Lynne, )
  Re: Feature freeze date for 8.1  (Christopher Browne, )
 Network write errors (was: Re: Feature freeze date for 8.1)  (Andrew - Supernews, )
  Re: Network write errors (was: Re: Feature freeze date for  (Bruce Momjian, )
   Re: Network write errors (was: Re: Feature freeze date for  (Tom Lane, )
 Re: Feature freeze date for 8.1  (Christopher Browne, )
 Re: Feature freeze date for 8.1  (Christopher Browne, )
 Re: Feature freeze date for 8.1  (Andrew - Supernews, )
 Re: Feature freeze date for 8.1  (Rob Butler, )
  Re: Feature freeze date for 8.1  (Bruno Wolff III, )
  Re: Feature freeze date for 8.1  (Andrew - Supernews, )
   Re: Feature freeze date for 8.1  (Tom Lane, )
   Re: Feature freeze date for 8.1  (<>, )
    Re: Feature freeze date for 8.1  ("Jim C. Nasby", )
     Re: Feature freeze date for 8.1  (Kris Jurka, )
 Re: Feature freeze date for 8.1  (Alvar Freude, )
 Re: Feature freeze date for 8.1  ("Chuck McDevitt", )
  Re: Feature freeze date for 8.1  (Oliver Jowett, )
 Re: Feature freeze date for 8.1  ("Chuck McDevitt", )
 Re: Feature freeze date for 8.1  ("Dave Held", )
 Re: Feature freeze date for 8.1  ("Dave Held", )
  Re: Feature freeze date for 8.1  (<>, )
  Re: Feature freeze date for 8.1  (Tom Lane, )
   Re: Feature freeze date for 8.1  (Doug McNaught, )
    Re: Feature freeze date for 8.1  (Simon Riggs, )
     Re: Feature freeze date for 8.1  (Kaare Rasmussen, )
      Re: Feature freeze date for 8.1  (Tom Lane, )
       Re: Feature freeze date for 8.1  (Andrew Dunstan, )
        Re: Feature freeze date for 8.1  (Bruce Momjian, )
  Re: Feature freeze date for 8.1  (Thomas Swan, )
 Re: Feature freeze date for 8.1  ("Dave Held", )
 Re: Feature freeze date for 8.1  ("Dave Held", )
  Re: Feature freeze date for 8.1  (Oliver Jowett, )
 Re: Feature freeze date for 8.1  ("Chuck McDevitt", )

On Fri, 29 Apr 2005, Christopher Browne wrote:

> Martha Stewart called it a Good Thing when  ("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).

Some way of doing a 'partial vacuum' would be nice ... where a VACUUM 
could stop after it processed those '10 elderly tuples' and on the next 
pass, resume from that point instead of starting from the beginning again 
...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email:            Yahoo!: yscrappy              ICQ: 7615664



В списке pgsql-hackers по дате сообщения:

От: "Joshua D. Drake"
Дата:
Сообщение: Re: Increased company involvement
От: "Nicolai Petri (lists)"
Дата:
Сообщение: Re: [pgsql-advocacy] Increased company involvement