Re: [HACKERS] copy table from file: with row replacement?

2007-01-12 Thread Bruce Momjian
Michael Enke wrote: Hello all, I have a feature request as I think it is not possible with the actual version: I want to load huge amount of data and I know that COPY is much faster than doing inserts. But in my case I have an already filled table and rows (not all, only partly) from

Re: [HACKERS] copy table from file: with row replacement?

2007-01-12 Thread Michael Enke
This works for small amount of data. But for large amount of data the join takes a lot of time. Regards, Michael Bruce Momjian wrote: Michael Enke wrote: Hello all, I have a feature request as I think it is not possible with the actual version: I want to load huge amount of data and I know

Re: [HACKERS] copy table from file: with row replacement?

2007-01-12 Thread Florian G. Pflug
Michael Enke wrote: This works for small amount of data. But for large amount of data the join takes a lot of time. It certainly is faster then anly algorithm that checks for duplicates for each lines of copy input could ever be. Especially for joins, doing them in one large batch allows you

[HACKERS] copy table from file: with row replacement?

2007-01-11 Thread Michael Enke
Hello all, I have a feature request as I think it is not possible with the actual version: I want to load huge amount of data and I know that COPY is much faster than doing inserts. But in my case I have an already filled table and rows (not all, only partly) from this table should be