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

Patch(es) to expose n_live_tuples and n_dead_tuples to SQL land

From: Glen Parker <glenebob(at)nwlink(dot)com>
To: Postgresql Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Patch(es) to expose n_live_tuples and n_dead_tuples to SQL land
Date: 2006-12-21 01:28:56
Message-ID: 4589E358.2010407@nwlink.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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.

-Glen Parker

Attachment: live_dead_tuples.diff
Description: text/plain (3.5 KB)

Responses

pgsql-hackers by date

Next:From: Glen ParkerDate: 2006-12-21 01:31:34
Subject: Re: Autovacuum Improvements
Previous:From: Takayuki TsunakawaDate: 2006-12-21 00:52:38
Subject: Re: Load distributed checkpoint

pgsql-patches by date

Next:From: ITAGAKI TakahiroDate: 2006-12-21 02:55:42
Subject: Re: Load distributed checkpoint
Previous:From: Takayuki TsunakawaDate: 2006-12-21 00:52:38
Subject: Re: Load distributed checkpoint

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