Skip site navigation (1) Skip section navigation (2)

Re: DELETE versus TRUNCATE during pg_dump....

From: Christopher Browne <cbbrowne(at)ca(dot)afilias(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DELETE versus TRUNCATE during pg_dump....
Date: 2004-12-21 20:46:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
pathat(at)comcast(dot)net (Patrick Hatcher) writes:
> Curious:  Why would a DELETE FROM tablename work while a pg_dump is
> occurring but a TRUNCATE tablename will stay in a lock state until the
> pg_dump is complete?

DELETE FROM merely has to mark all the tuples as dead, which requires
no control over the table as a whole.

TRUNCATE essentially reinitializes the table as empty, which does need
a (if brief) lock on the table.

Yeah, you can't TRUNCATE while the dump is running...
Christopher Browne
(416) 673-4124 (land)

In response to

pgsql-general by date

Next:From: Vladimir S. PetukhovDate: 2004-12-21 20:47:31
Subject: Re: Need help to organize database
Previous:From: Greg StarkDate: 2004-12-21 20:42:22
Subject: Re: Scheduler in Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group