Postgres Pro
Downloads
Home   >   mailing lists

Re: Drop table vs begin/end transaction - Mailing list pgsql-novice

From Tom Lane
Subject Re: Drop table vs begin/end transaction
Date
Msg-id 2100.1006061854@sss.pgh.pa.us
Whole thread Raw
In response to Drop table vs begin/end transaction  (Francisco Reyes <lists@natserv.com>)
Responses Re: Drop table vs begin/end transaction
List pgsql-novice
Tree view 
Francisco Reyes <lists@natserv.com> writes:
> My alternative is to use delete from <table>. Besides been slower I wonder
> if this would not make my "vacuum analyze" run much slower.

Consider TRUNCATE TABLE, also.  However, that's not transactional,
so the drop/create/fill might be a better bet if you are worried
about bad data during the fill.

            regards, tom lane

pgsql-novice by date:

Previous
From: Francisco Reyes
Date:
Subject: Drop table vs begin/end transaction
Next
From: Francisco Reyes
Date:
Subject: Re: Drop table vs begin/end transaction