| 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: | Whole Thread | Raw Message | 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 |