From: | Mario Amado Alves <maa(at)di(dot)fct(dot)unl(dot)pt> |
---|---|
To: | Tim White <twhite(at)friendlyworks(dot)com> |
Cc: | pgsql admin mail list <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: copy command and indexes |
Date: | 2000-06-14 11:06:03 |
Message-ID: | Pine.LNX.4.10.10006141156510.18157-100000@lexis.di.fct.unl.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On my experience it is better to recreate the indexes.
My experience is trasferring data between several Postgres systems of
different versions---and you know how Postgres versions are
incompatible---, so I have to recreate the indexes (and sometimes the
classes).
In general I dont know if it is at all possible for copy to update the
indexes; I dont think so.
On Tue, 13 Jun 2000, Tim White wrote:
> When using the copy command to bulk load data, will it update the indexes,
> or do you have to explicitly drop and recreate the indexes?
>
> Thanks,
>
> Tim
>
| |,| | | |RuaFranciscoTaborda24RcD 2815-249CharnecaCaparica 351+939354002
|M|A|R|I|O|
|A|M|A|D|O|DepartmentoDeInformaticaFCT/UNL 2825-114 Caparica 351+212958536
|A|L|V|E|S| fax 212948541
| | | | | | maa(at)di(dot)fct(dot)unl(dot)pt FCT 212948300
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-06-14 11:19:20 | Re: Money Data type |
Previous Message | Dana Hudes | 2000-06-14 02:54:51 | Re: Money Data type |