Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Can I deactivate indexes?
- From: <bmccoy(at)chapelperilous(dot)net>
- To: DaVinci <bombadil(at)wanadoo(dot)es>
- Cc: Lista PostgreSql <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Can I deactivate indexes?
- Date: Wed, 25 Oct 2000 10:07:55 -0400 (EDT)
- Message-id: <Pine.LNX.4.10.10010251007060.4999-100000@chapelperilous.net> <text/plain>
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
- References:
- Can I deactivate indexes?
- From: DaVinci
- Can I deactivate indexes?
- Prev by Date: Re: Can I deactivate indexes?
- Next by Date: Postgres with Solaris 2.6
- Previous by thread: Re: Can I deactivate indexes?
- Next by thread: [OT] Is there any site with list archives?
- Indexes: