Postgres Pro
Downloads
Home   >   mailing lists

When is it worth it to drop indexes on bulk loads? - Mailing list pgsql-novice

From Francisco Reyes
Subject When is it worth it to drop indexes on bulk loads?
Date
Msg-id 20011118160631.L70739-100000@zoraida.natserv.net
Whole thread Raw
List pgsql-novice
Tree view 
Any general ideas when it may be worth dropping an index when bulk
loading data?

I have a number of tables which I would be copying over every night from
another system. Some are as small as 50K records while others are 500K+. I
am just curious what is the borderline? 100K rows?

I am using the copy command.

pgsql-novice by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Drop table vs begin/end transaction
Next
From: Francisco Reyes
Date:
Subject: Re: Drop table vs begin/end transaction