Re: Alternative to drop index, load data, recreate index?

Depesz,

Thank you for the suggestion- I thought I had read up on that tool
earlier but had somehow managed to forget about it when starting this
phase of my investigation.

Needless to say, I can confirm the claims made on the project homepage
when using very large data sets.

- Loading 1.2M records into an indexed table:
- pg_bulkload: 5m 29s
- copy to: 53m 20s

These results were obtained using pg-8.2.4 with pg_bulkload-2.2.0.

-jason

hubert depesz lubaczewski wrote:
> 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
>
>