Skip site navigation (1) Skip section navigation (2)

vacuum bug

From: "geva" <geva(at)regard(dot)co(dot)il>
To: pgsql-bugs(at)postgresql(dot)org
Subject: vacuum bug
Date: 2002-10-20 11:32:16
Message-ID: aou47s$19ui$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
    i'm encountering  an recurring problem in which running vacuum on a
relatively large
    database ( >30000 rows) causes the database to corrupt rather badly. all
subsequent  calls to  vacuum does not return, and the only solution is to
pg_dump the database, drop all or some of the tables, and recover the
database using \i or psql -e.

    i am working with version 7.0 .

    is it a known bug ? was it solved on later versions? is there a
workaround?




Responses

pgsql-bugs by date

Next:From: Casey Allen ShobeDate: 2002-10-22 03:06:22
Subject: Odd random drop sequence failure
Previous:From: Arne WoernerDate: 2002-10-19 12:49:54
Subject: 10 concurrent clients / pure insert SQL scripts (each 100000 lines)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group