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

Re: copy command and indexes

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: (view raw, whole thread or download thread mbox)
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

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
|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

In response to

pgsql-admin by date

Next:From: Peter EisentrautDate: 2000-06-14 11:19:20
Subject: Re: Money Data type
Previous:From: Dana HudesDate: 2000-06-14 02:54:51
Subject: Re: Money Data type

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group