Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? - Mailing list pgsql-general

From postgres@taifun.interface-business.de
Subject Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
Date
Msg-id XFMail.991214102647.postgres@taifun.interface-business.de
Whole thread Raw
In response to Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?  (Ed Loehr <ELOEHR@austin.rr.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Elmar.Haneke@gmx.de
Date:
Subject: Access rescrictions
Next
From: Mark Jewiss
Date:
Subject: Re: [GENERAL] Clients in different Time Zones