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

Re: Drop table vs begin/end transaction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Francisco Reyes <lists(at)natserv(dot)com>
Cc: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Drop table vs begin/end transaction
Date: 2001-11-18 05:37:34
Message-ID: 2100.1006061854@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Francisco Reyes <lists(at)natserv(dot)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

In response to

Responses

pgsql-novice by date

Next:From: Francisco ReyesDate: 2001-11-18 21:01:52
Subject: Re: Drop table vs begin/end transaction
Previous:From: Francisco ReyesDate: 2001-11-18 04:24:12
Subject: Drop table vs begin/end transaction

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