View Single Post

   
  #1 (permalink)  
Old 04-18-2008, 09:11 AM
Glen Parker
 
Posts: n/a
Default Re: Patch(es) to expose n_live_tuples and

I'd love to see this back patched into 8.2.1 if possible.

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

Reply With Quote