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 a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general