| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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 | Content-Type | Size |
|---|---|---|
| live_dead_tuples.diff | text/plain | 3.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Glen Parker | 2006-12-21 01:31:34 | Re: Autovacuum Improvements |
| Previous Message | Takayuki Tsunakawa | 2006-12-21 00:52:38 | Re: Load distributed checkpoint |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ITAGAKI Takahiro | 2006-12-21 02:55:42 | Re: Load distributed checkpoint |
| Previous Message | Takayuki Tsunakawa | 2006-12-21 00:52:38 | Re: Load distributed checkpoint |