From: | Neil Conway <neilc(at)samurai(dot)com> |
---|---|
To: | Kevin Old <kold(at)carolina(dot)rr(dot)com> |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org>, scott(dot)marlowe(at)ihs(dot)com |
Subject: | Re: my.cnf to postgresql.conf Conversion |
Date: | 2002-11-01 16:48:06 |
Message-ID: | 877kfxme2h.fsf@mailbox.samurai.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Kevin Old <kold(at)carolina(dot)rr(dot)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(at)samurai(dot)com> || PGP Key ID: DB3C29FC
From | Date | Subject | |
---|---|---|---|
Next Message | Gary DeSorbo | 2002-11-01 17:24:14 | DB Performance |
Previous Message | scott.marlowe | 2002-11-01 16:43:35 | Re: my.cnf to postgresql.conf Conversion |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-01 16:51:01 | Re: FIFO Queue Problems |
Previous Message | Ken Guest | 2002-11-01 16:47:02 | Re: postgres on a FreeBSD 4.5 box |