pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
3+ messages / 3 participants
[nested] [flat]
* Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
@ 1999-12-13 20:04 Ed Loehr <ELOEHR@austin.rr.com>
1999-12-14 06:45 ` Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? Adriaan Joubert <a.joubert@albourne.com>
1999-12-14 09:26 ` Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? postgres@taifun.interface-business.de
0 siblings, 2 replies; 3+ messages in thread
From: Ed Loehr @ 1999-12-13 20:04 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Question: is it safe to insert/update/delete during VACUUM?
Ed
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
1999-12-13 20:04 Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? Ed Loehr <ELOEHR@austin.rr.com>
@ 1999-12-14 06:45 ` Adriaan Joubert <a.joubert@albourne.com>
1 sibling, 0 replies; 3+ messages in thread
From: Adriaan Joubert @ 1999-12-14 06:45 UTC (permalink / raw)
To: Ed Loehr <ELOEHR@austin.rr.com>; +Cc: pgsql-general@postgresql.org
Ed Loehr wrote:
>
> Question: is it safe to insert/update/delete during VACUUM?
>
It is supposed to be (MVCC should take care of it), but in practice I've
got bad experiences with it. The system should at least have a very low
load. You can get dead-lock errors, as the tables being vacuumed are
locked for a long time and then inaccessible to other queries (that's
unavoidable, but still annoying). And a couple of times something went
wrong and I ended up with duplicate tuples in my tables -- really
duplicate, including the oid's. That required a table
dump/sort/uniq/load to fix :-(.
Adriaan
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
1999-12-13 20:04 Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? Ed Loehr <ELOEHR@austin.rr.com>
@ 1999-12-14 09:26 ` postgres@taifun.interface-business.de
1 sibling, 0 replies; 3+ messages in thread
From: postgres@taifun.interface-business.de @ 1999-12-14 09:26 UTC (permalink / raw)
To: Ed Loehr <ELOEHR@austin.rr.com>; +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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-12-14 09:26 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-12-13 20:04 Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? Ed Loehr <ELOEHR@austin.rr.com>
1999-12-14 06:45 ` Adriaan Joubert <a.joubert@albourne.com>
1999-12-14 09:26 ` postgres@taifun.interface-business.de
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