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

Re: pg_avd

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>,Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_avd
Date: 2003-02-19 21:37:50
Message-ID: 200302192137.h1JLboC14021@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Matthew T. O'Connor wrote:
> I don't think pg_avd is contorted, but it is limited to the data
> published by the stats system, so there is no FSM etc...
> 
> I also think it would probably be better in the backend, I just wasn't
> sure if the additional complexity was worth it.  The primary advantage
> of a client side implementation is simplicity.
> 
> That said, I originally tried to do this in the backend, but found the
> task too daunting for me and gave up.  When Shridhar started some work
> on a client side version I decided to run with that and see how far I
> could get.
> 
> Question:  Should I keep working on pg_avd for contrib inclusion in 7.4,
> or should I try again on a backend implementation that might be less
> likely to get into 7.4?

Well, one idea would be to write a loadable function that dumps out FSM
information --- then you could improve your implementation and
eventually put it in the backend.  I would like to have something for
7.4.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

  • Re: pg_avd at 2003-02-19 16:06:30 from Matthew T. O'Connor

Responses

  • Re: pg_avd at 2003-02-19 23:32:33 from Magnus Naeslund(f)

pgsql-patches by date

Next:From: Bruce MomjianDate: 2003-02-19 21:53:49
Subject: Re: The last configuration file patch (I hope!) This one
Previous:From: Neil ConwayDate: 2003-02-19 20:45:00
Subject: Re: implement query_start for pg_stat_activity

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