pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: postgres@taifun.interface-business.de
To: Ed Loehr <ELOEHR@austin.rr.com>
Cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
Date: Tue, 14 Dec 1999 10:26:47 +0100 (CET)
Message-ID: <XFMail.991214102647.postgres@taifun.interface-business.de> (raw)
In-Reply-To: <38555166.32D789CA@austin.rr.com>

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



view thread (3+ messages)

Message-ID: <XFMail.991214102647.postgres@taifun.interface-business.de>
Permalink:  ../XFMail.991214102647.postgres@taifun.interface-business.de/
Also on:    postgresql.org/message-id/XFMail.991214102647.postgres@taifun.interface-business.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: postgres@taifun.interface-business.de, ELOEHR@austin.rr.com, pgsql-general@postgreSQL.org
  Subject: Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
  In-Reply-To: <XFMail.991214102647.postgres@taifun.interface-business.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox