Re: Alternative to drop index, load data, recreate index? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Alternative to drop index, load data, recreate index?
Date
Msg-id 20070911093704.GA1285@depesz.com
Whole thread Raw
In response to Alternative to drop index, load data, recreate index?  ("Jason L. Buberel" <jason@buberel.org>)
Responses Re: Alternative to drop index, load data, recreate index?  ("Jason L. Buberel" <jason@buberel.org>)
List pgsql-general
On Mon, Sep 10, 2007 at 05:06:35PM -0700, Jason L. Buberel wrote:
> I am considering moving to date-based partitioned tables (each table =
> one month-year of data, for example). Before I go that far - is there
> any other tricks I can or should be using to speed up my bulk data loading?

did you try pgbulkload? (http://pgbulkload.projects.postgresql.org/)

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

pgsql-general by date:

Previous
From: 李彦 Ian Li
Date:
Subject: Re: Debian problem...
Next
From: "Phoenix Kiula"
Date:
Subject: Partial index with regexp not working