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

Re: pgstattuple extension for indexes

From: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-patches(at)postgresql(dot)org,ishii(at)sraoss(dot)co(dot)jp
Subject: Re: pgstattuple extension for indexes
Date: 2006-07-24 06:54:44
Message-ID: 20060724144315.699D.ITAGAKI.TAKAHIRO@oss.ntt.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> >> Also, I added an experimental feature for btree indexes. It checks
> >> fragmentation factor of indexes.

> The really serious problem with reporting this info via NOTICE is that
> there's no way for a program to get its hands on the info.  The output
> tuple format needs to be extended instead.

Ok, I added 'fragmented_percent' field to the output tuple. This
information will help us to decide when to do REINDEX.
However, it is only avaliable for btree index presently. Other indexes
should have equivalent information, but I don't know how to determine it.


BTW, should we change VACUUM VERBOSE in the same way? If we do so,
autovacuum can handle the reports of VACUUM VERBOSE and plan when to
do VACUUM FULL, REINDEX and/or CLUSTER using the information.
Is this worth doing?

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center


Attachment: pgstattuple-0724.patch
Description: application/octet-stream (11.7 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Dave PageDate: 2006-07-24 07:31:01
Subject: Re: Adding a pgbench run to buildfarm
Previous:From: Jie ZhangDate: 2006-07-24 06:23:48
Subject: Re: On-disk bitmap index patch

pgsql-patches by date

Next:From: Peter EisentrautDate: 2006-07-24 09:52:12
Subject: Re: Mark change-on-restart-only values in postgresql.conf
Previous:From: Joe ConwayDate: 2006-07-24 06:22:14
Subject: Re: Values list-of-targetlists patch for comments (was Re:

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