From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: populate table with large csv file |
Date: | 2003-09-26 12:37:35 |
Message-ID: | 1064579855.26936.57.camel@haggis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
On Fri, 2003-09-26 at 06:58, Dave [Hawk-Systems] wrote:
[snip]
> Unfortunately processing the 143mb file which would result in a database size of
> approx 500mb takes an eternity. As luck would have it we can get away with just
Something's not right, then. I loaded 30GB in about 8 hours, on
a slow system, with non-optimized IO. Did you drop the indexes
first?
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
"As the night fall does not come at once, neither does
oppression. It is in such twilight that we must all be aware of
change in the air - however slight - lest we become unwitting
victims of the darkness."
Justice William O. Douglas
From | Date | Subject | |
---|---|---|---|
Next Message | Tim McAuley | 2003-09-26 14:00:30 | Re: sequence's plpgsql |
Previous Message | Dave [Hawk-Systems] | 2003-09-26 11:58:16 | Re: populate table with large csv file |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-26 14:35:36 | Re: Indices arent being used |
Previous Message | Dave [Hawk-Systems] | 2003-09-26 11:58:16 | Re: populate table with large csv file |