Re: [HACKERS] Optimizer fed bad data about some system-table indexes

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Optimizer fed bad data about some system-table indexes
Date: 1999-04-30 19:26:59
Message-ID: 199904301926.PAA28952@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> The vacuum analyze *does* fix the data that's in the pg_class entry
> for the index. Trouble is that the relcache entry for the index is
> never read from pg_class; it's loaded from this never-updated init file.
>
> One possible answer is to rewrite the init file as the final step of
> a vacuum, using the just-updated pg_class data. But I'm still not
> convinced that we really need the init file at all...

Can you point me to that file?

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-04-30 19:52:35 Re: [HACKERS] Optimizer fed bad data about some system-table indexes
Previous Message Tom Lane 1999-04-30 19:06:01 Re: [HACKERS] Optimizer fed bad data about some system-table indexes