| From: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-25 04:12:12 |
| Message-ID: | 20060725130246.5D05.ITAGAKI.TAKAHIRO@oss.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> Satoshi Nagayasu wrote:
> > I'm working on an utility for b-tree index, called `pgstatindex`.
>
> Does it make sense to merge the pgstatindex stuff with pgstattuple, and
> have the fragmentation report into pgstatindex instead of pgstattuple
> itself?
It sounds good. We will have two separate commands:
- pgstattuple: returns tuple-level information
- pgstatindex: returns page-level information
We can use tuple-level info to check LP_DELETE flags on index tuples,
and use page-level info to check needs for REINDEX.
Do we add pgstatindex as a new contrib module,
or merge it into contrib/pgstattuple?
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-07-25 04:13:38 | Re: effective_cache_size is a real? |
| Previous Message | Tom Lane | 2006-07-25 03:59:34 | Re: Time zone definitions to config files |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dhanaraj M | 2006-07-25 04:15:59 | [Fwd: Re: Patch for - Change LIMIT/OFFSET to use int8] |
| Previous Message | Tom Lane | 2006-07-25 03:59:34 | Re: Time zone definitions to config files |