| From: | postgres(at)taifun(dot)interface-business(dot)de |
|---|---|
| To: | Ed Loehr <ELOEHR(at)austin(dot)rr(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? |
| Date: | 1999-12-14 09:26:47 |
| Message-ID: | XFMail.991214102647.postgres@taifun.interface-business.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Jewiss | 1999-12-14 11:06:39 | Re: [GENERAL] Clients in different Time Zones |
| Previous Message | Elmar.Haneke | 1999-12-14 08:30:51 | Access rescrictions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Osborne | 1999-12-14 14:23:59 | Re: [INTERFACES] Duplicate INSERTS into pgsql table via PHP |
| Previous Message | Constantin Teodorescu | 1999-12-14 08:42:59 | Tcl 8.2 , multithreading and libpgtcl |