From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] Cache on pg_statistics |
Date: | 1999-11-24 06:16:27 |
Message-ID: | 9374.943424187@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom, let me know what caches you want on pg_statistics, or if you would
> prefer to do it yourself, instructions are at the top of syscache.c.
AFAIK the only index we need is one on starelid + staattnum. If you
have the time, please put it in and teach getattstatistics() in
backend/utils/adt/selfuncs.c to use it. That seems to be the only
place that reads pg_statistic.
If you wanted to include staop as a third column, then the index could
be UNIQUE. (We don't actually use staop at the moment, but I think it
should be left in place for possible future use.)
vacuum.c may also need to be taught to fill the index...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-11-24 06:29:01 | Re: AW: [HACKERS] Getting OID in psql of recent insert |
Previous Message | Tatsuo Ishii | 1999-11-24 06:11:59 | pid file for postmaster? |