When is it worth it to drop indexes on bulk loads?

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: When is it worth it to drop indexes on bulk loads?
Date: 2001-11-18 21:12:50
Message-ID: 20011118160631.L70739-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Browse pgsql-novice by date

  From Date Subject
Next Message Francisco Reyes 2001-11-18 22:01:16 Re: Drop table vs begin/end transaction
Previous Message Francisco Reyes 2001-11-18 21:01:52 Re: Drop table vs begin/end transaction