Re: are there any methods to disable updating index before inserting large number tuples?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: are there any methods to disable updating index before inserting large number tuples?
Дата
Msg-id 20111122155206.GF7661@shinkuro.com
обсуждение исходный текст
Ответ на are there any methods to disable updating index before inserting large number tuples?  (sunpeng <bluevaley@gmail.com>)
Ответы Re: are there any methods to disable updating index before inserting large number tuples?
Список pgsql-general
Дерево обсуждения 
On Tue, Nov 22, 2011 at 11:47:15PM +0800, sunpeng wrote:
>   >disable index update
>   >insert into A ....//here will insert 20 millions tuples
>   > enable index update
>

BEGIN;
DROP INDEX;
INSERT INTO A;
CREATE INDEX;

But I think performance on that table is going to be pretty bad.  I
suspect that COPY is going to be your friend here.

A

--
Andrew Sullivan
ajs@crankycanuck.ca

В списке pgsql-general по дате отправления:

Предыдущее
От: sunpeng
Дата:
Сообщение: are there any methods to disable updating index before inserting large number tuples?
Следующее
От: Gregg Jaskiewicz
Дата:
Сообщение: Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data