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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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)

Browse pgsql-patches by date

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