Received: from innocence.interface-business.de
	(innocence.interface-business.de [193.101.57.202])
	by hub.org (8.9.3/8.9.3) with ESMTP id EAA01139
	for <pgsql-general@postgreSQL.org>;
	Tue, 14 Dec 1999 04:26:48 -0500 (EST)
	(envelope-from gerald@mauz.interface-business.de)
Received: from mauz.interface-business.de (mauz.interface-business.de
	[193.101.57.233])
	by innocence.interface-business.de with ESMTP id KAA52943;
	Tue, 14 Dec 1999 10:26:47 +0100 (CET)
Received: (from gerald@localhost)
	by mauz.interface-business.de (8.8.8/8.8.8) id KAA22938;
	Tue, 14 Dec 1999 10:26:47 +0100 (CET) (envelope-from gerald)
Message-ID: <XFMail.991214102647.postgres@taifun.interface-business.de>
X-Mailer: XFMail 1.3 [p0] on FreeBSD
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
In-Reply-To: <38555166.32D789CA@austin.rr.com>
Date: Tue, 14 Dec 1999 10:26:47 +0100 (CET)
Reply-To: gerald@interface-business.de
Organization: Interface Business
Sender: gerald@mauz.interface-business.de
From: postgres@taifun.interface-business.de
To: Ed Loehr <ELOEHR@austin.rr.com>
Subject: Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
Cc: pgsql-general@postgreSQL.org

Hi Ed,

> Question:  is it safe to insert/update/delete during VACUUM?

We have done a stress test on FreeBSD 2.2.7 with PG 6.4.3 and
6.5.2 with 2 processes in parallel: the first runs VACUUM VERBOSE
in a loop and the second does INSERT/UPDATE/DELETE's.
The database crashed after <5 mins, with different errors (not
only "duplicate tuples").

Howto VACUUM an online database?

Gerald