I need to append rows to an existing table that is in a production db.
There are 60 fields in the table and 17 indexes, including the primary key.
I cannot drop the indexes because the data is being actively accessed by
users. I can't create a duplicate table because we do not have enough disk
storage to do so at this time.
I believe that the SQL COPY statement will delay updating the indexes until
after it has inserted the rows because (again, I believe) the copy is
treated as a single transaction that either succeeds or fails.
I would appreciate knowing if I am correct about this.
pgsql-novice by date
|Next:||From: Sean Davis||Date: 2007-07-04 20:57:17|
|Subject: Re: COPY and index updating|
|Previous:||From: Tiemo Kieft||Date: 2007-07-03 20:48:40|
|Subject: Re: Multiple inserts into 2 tables with FKs|