Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 25 Oct 2000 13:17:58 +0200
  • Message-id: <20001025131758.A7975@fangorn.net> <text/plain>
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
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group