On Wed, 25 Oct 2000, DaVinci wrote:
> I want to use key words like SERIAL, PRIMARY KEY, etc, for creating tables,
> but this words create indexes asociated to tables.
>
> If i use COPY to poblate tables, indexes make tranfer very slow.
>
> How can i deactivate indexes temporaly for making a COPY?.
You should drop all of your indexes when you do a bulk copy and then
rebuild them afterwards. You can drop indexes with the DROP INDEX
statement.
Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Everything takes longer, costs more, and is less useful.
-- Erwin Tomash