Can I deactivate indexes?

From: DaVinci <bombadil(at)wanadoo(dot)es>
To: Lista PostgreSql <pgsql-general(at)postgresql(dot)org>
Subject: Can I deactivate indexes?
Date: 2000-10-25 11:17:58
Message-ID: 20001025131758.A7975@fangorn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DaVinci 2000-10-25 11:26:47 [OT] Is there any site with list archives?
Previous Message Vilson farias 2000-10-25 10:50:47 Re: Delete temp tables