vacuum problems - Mailing list pgsql-general

From Sebestyen Zoltan
Subject vacuum problems
Date
Msg-id Pine.LNX.3.96.990203164605.7012D-100000@linux.intranet.netvisor.hu
Whole thread Raw
Responses Re: [GENERAL] vacuum problems
List 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 by date:

Previous
From: "Alex P. Rudnev"
Date:
Subject: Re: [GENERAL] Cost: Big Tables vs. Organized Separation of Data
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Cost: Big Tables vs. Organized Separation of Data