Re: [GENERAL] COPY speedup

2007-12-13 Thread Merlin Moncure
On Dec 13, 2007 4:31 PM, Reg Me Please <[EMAIL PROTECTED]> wrote: > Il Thursday 13 December 2007 19:56:02 Tom Lane ha scritto: > > Reg Me Please <[EMAIL PROTECTED]> writes: > > > In order to speed up the COPY ... FROM ... command, I've > > > disabled everything (primary key, not null, references, d

Re: [GENERAL] COPY speedup

2007-12-13 Thread Reg Me Please
Il Thursday 13 December 2007 19:56:02 Tom Lane ha scritto: > Reg Me Please <[EMAIL PROTECTED]> writes: > > In order to speed up the COPY ... FROM ... command, I've > > disabled everything (primary key, not null, references, default and > > indexes) in the table definition before doing the actual CO

Re: [GENERAL] COPY speedup

2007-12-13 Thread Tom Lane
Reg Me Please <[EMAIL PROTECTED]> writes: > In order to speed up the COPY ... FROM ... command, I've > disabled everything (primary key, not null, references, default and indexes) > in the table definition before doing the actual COPY. > Later I can restore them with ALTER TABLE ... and CREATE INDE