vacuum problems

Поиск
Список
Период
Сортировка
От Sebestyen Zoltan
Тема vacuum problems
Дата
Msg-id Pine.LNX.3.96.990203164605.7012D-100000@linux.intranet.netvisor.hu
обсуждение исходный текст
Ответы Re: [GENERAL] vacuum problems  ("Giovanni Floridia" <gfloridia@provider.com.br>)
Список pgsql-general
Hi,
 I'm writing a logfile processing app.
 everytime I processed a logfile and moved the information into a
relation, I try to vacuum it. But after a while (after the nth logfile)
vacuum freezes with the following message:

NOTICE:  BlowawayRelationBuffers(annex_log, 7): block 7 is referenced
(private 0, last 0, global 1)
FATAL 1:  VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2

 What went wrong?

    Thanks in advance

--------------------------------------------------------------------------------
Sebestyén Zoltán <szoli@netvisor.hu>    I'm believing that the Holy Spirit is
                    gonna allow the hand, and the foot, and
MAKE INSTALL NOT WAR            the mouth, just to begin to speak, and
                                        to minister, and to heal coordinated by
                    the head.

I use UNIX because reboots are for hardware upgrades.

           -- Waiting for FreeBSD 3.1, not Godot --



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

Предыдущее
От: "Alex P. Rudnev"
Дата:
Сообщение: Re: [GENERAL] Cost: Big Tables vs. Organized Separation of Data
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Cost: Big Tables vs. Organized Separation of Data