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