Postgres Pro
Downloads
Home   >   mailing lists

DELETE versus TRUNCATE during pg_dump.... - Mailing list pgsql-general

From Patrick Hatcher
Subject DELETE versus TRUNCATE during pg_dump....
Date
Msg-id 41C7F935.5060807@comcast.net
Whole thread Raw
Responses Re: DELETE versus TRUNCATE during pg_dump....  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Pg 7.4.5

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?

About 60% of our tables are refreshed daily from our Filemaker database
and we don't care if one or more of these tables are empty while we do
our daily backups.

TIA

Patrick

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: weird run-times with pg_autovacuum
Next
From: Dick Davies
Date:
Subject: Re: Create a cache DB between web portal and internal DB?