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

[GENERAL] COPY speedup

2007-12-13 Thread Reg Me Please
Hi all. 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 INDEX ... My question is: is all this necessa