Re: [HACKERS] Index corruption

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Index corruption
Дата
Msg-id 199912291407.JAA02208@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Index corruption  (Adriaan Joubert <a.joubert@albourne.com>)
Список pgsql-hackers
> Further to my problem: I've run the vacuum in a backend under the debugger and
> at least figured out in which
> loop the zillions of files are created. It is in md.c. In the stack trace
> below, you can see that blockno has got a totally stupid value and in the loop
> in lines 1049-1063 in md.c (v 6.5.3. sources) it opens zillions of files. If
> anybody knows where this comes from I'd appreciate it. In the meantime I'll
> try to dig a bit further.

Were you the person I told to use pg_upgrade and re-initdb your
database? If not, I would recommend that as the fix.  You may need to
re-enable pg_upgrade by editing the script.

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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: subquery performance and EXISTS
Следующее
От: Adriaan Joubert
Дата:
Сообщение: Re: [HACKERS] Index corruption