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

From Francisco Reyes
Subject Re: Drop table vs begin/end transaction
Date
Msg-id 20011118160004.B70739-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Drop table vs begin/end transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Drop table vs begin/end transaction
List pgsql-novice
On Sun, 18 Nov 2001, Tom Lane wrote:

> 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

Thanks for the info. Didn't know about truncate table

> so the drop/create/fill might be a better bet if you are worried
> about bad data during the fill.

I just had such a case. The table I was importing had a '\' and postgreSQL
didn't like it. I guess it must have some special meaning.


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Drop table vs begin/end transaction
Next
From: Francisco Reyes
Date:
Subject: When is it worth it to drop indexes on bulk loads?