On Wed, Dec 14, 2005 at 06:18:07PM -0500, Kevin Keith wrote:
> Or can a transaction be bypassed altogether with the COPY command since
> any failure (the load is going to an empty table) could easily be solved
> with a reload of the data anyway.
Work along those lines is currently in-progress.
Kevin Keith <[EMAIL PROTECTED]> writes:
> I was trying to run a bulk data load using the COPY command on PGSQL 8.1.0.
> After loading about 3,500,000 records it ran out of memory - I am
> assuming because it ran out of space to store such a large transaction.
COPY per se shouldn't eat memory.
P
I was trying to run a bulk data load using the COPY command on PGSQL 8.1.0.
After loading about 3,500,000 records it ran out of memory - I am
assuming because it ran out of space to store such a large transaction.
Does the COPY command offer a similar feature to Oracle's SQL*Loader
where you c
