| 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: | 2000-10-25 14:07:55 |
| Message-ID: | Pine.LNX.4.10.10010251007060.4999-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DaVinci | 2000-10-25 14:11:59 | Re: Can I deactivate indexes? |
| Previous Message | Vince Vielhaber | 2000-10-25 14:01:17 | Re: [OT] Is there any site with list archives? |