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
pgsql-novice by date
|Next:||From: Francisco Reyes||Date: 2001-11-18 21:01:52|
|Subject: Re: Drop table vs begin/end transaction |
|Previous:||From: Francisco Reyes||Date: 2001-11-18 04:24:12|
|Subject: Drop table vs begin/end transaction|