Kevin Old <kold@carolina.rr.com> writes:
> My perl code and tables/queries are as optimized as they can
> be....postgres shows that the size is only about 3,000K when viewed in
> top and running the copy command......so I assume it's problem with
> memory allocation.
Disabling fsync should help. Also, consider removing any indexes /
foreign keys on the table you're copying into, and then re-adding them
when the bulk load is finished.
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC