Postgres Pro
Downloads
Home   >   mailing lists

Can I deactivate indexes? - Mailing list pgsql-general

From DaVinci
Subject Can I deactivate indexes?
Date
Msg-id 20001025131758.A7975@fangorn.net
Whole thread Raw
Responses Re: Can I deactivate indexes?  (DaVinci <bombadil@wanadoo.es>)
Re: Can I deactivate indexes?  (<bmccoy@chapelperilous.net>)
List pgsql-general
Tree view 
Question is:

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?.

Any other strategy?.

Thanks for your ideas.

                        David

pgsql-general by date:

Previous
From: DaVinci
Date:
Subject: [OT] Is there any site with list archives?
Next
From: Vince Vielhaber
Date:
Subject: Re: three things