Re: [HACKERS] Optimizer fed bad data about some system-table indexes
От | Tom Lane |
---|---|
Тема | Re: [HACKERS] Optimizer fed bad data about some system-table indexes |
Дата | |
Msg-id | 11096.925585608@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] Optimizer fed bad data about some system-table indexes (Bruce Momjian <maillist@candle.pha.pa.us>) |
Ответы |
Re: [HACKERS] Optimizer fed bad data about some system-table indexes
|
Список | pgsql-hackers |
Bruce Momjian <maillist@candle.pha.pa.us> writes: > Hmm. If you can get it to work without the file, great, or you could > just delete the file when vacuum is performed, so the next backend > recreates the file. That would work too. That's a good idea. I made a test database with a couple thousand tables in it, and found that when pg_class gets that big it does take a measurable amount of time to rebuild the index info if the relcache init file is not there. (Looked like about a third of a second on my machine.) Since backend startup time is a hotbutton item for some folks, I'm not going to take out the init file code. I'll just make VACUUM remove the file, and then the first backend start after a VACUUM will rebuild the file with up-to-date statistics for the system indexes. regards, tom lane
В списке pgsql-hackers по дате отправления: