Re: Patch(es) to expose n_live_tuples and

On Tue, 2006-12-26 at 13:59 -0800, Glen Parker wrote:
> I'd love to see this back patched into 8.2.1 if possible.

Probably not. We typically do not introduce new features into back
releases.

Sincerely,

Joshua D. Drake


>
> Should I resubmit with new names?
>
> -Glen
>
> Bruce Momjian wrote:
> > Is this something we want in 8.3?  I am thinking visible/expired would
> > be clearer terms.
> >
> > ---------------------------------------------------------------------------
> >
> > Glen Parker wrote:
> >> This patch consists of two c functions to expose n_live_tuples and
> >> n_dead_tuples, SQL functions to expose them to SQL land, and
> >> corresponding fields added to pg_stat_all_tables.
> >>
> >> This has been discussed in general.  The purpose is to allow
> >> autovacuum-esq conditional vacuuming and clustering using SQL to
> >> discover the required stats.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate