Re: Drop table vs begin/end transaction

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Drop table vs begin/end transaction
Дата
Msg-id 20011118160004.B70739-100000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Re: Drop table vs begin/end transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Drop table vs begin/end transaction  (Francisco Reyes <lists@natserv.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Drop table vs begin/end transaction
Следующее
От: Francisco Reyes
Дата:
Сообщение: When is it worth it to drop indexes on bulk loads?