View Single Post

   
  #2 (permalink)  
Old 04-18-2008, 09:11 AM
Joshua D. Drake
 
Posts: n/a
Default 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




---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote