Postgres Pro
Downloads
Home   >   mailing lists

Re: are there any methods to disable updating index before inserting large number tuples? - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: are there any methods to disable updating index before inserting large number tuples?
Date
Msg-id 20111122155206.GF7661@shinkuro.com
Whole thread Raw
In response to are there any methods to disable updating index before inserting large number tuples?  (sunpeng <bluevaley@gmail.com>)
Responses Re: are there any methods to disable updating index before inserting large number tuples?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: sunpeng
Date:
Subject: are there any methods to disable updating index before inserting large number tuples?
Next
From: Gregg Jaskiewicz
Date:
Subject: Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data