Re: any solution for doing a data file import spawning it on multiple processes

From: Bosco Rama <postgres(at)boscorama(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: "hb(at)101-factory(dot)eu" <hb(at)101-factory(dot)eu>
Subject: Re: any solution for doing a data file import spawning it on multiple processes
Date: 2012-06-16 16:15:44
Message-ID: 4FDCB130.4090201@boscorama.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hb(at)101-factory(dot)eu wrote:
> thanks i thought about splitting the file, but that did no work out well.
>
> so we receive 2 files evry 30 seconds and need to import this as fast as possible.
>
> we do not run java curently but maybe it's an option.
> are you willing to share your code?
>
> also i was thinking using perl for it

Not sure if this will help, but have you looked at pgloader?

<http://pgloader.projects.postgresql.org/>

Bosco.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edson Richter 2012-06-16 16:23:21 Re: any solution for doing a data file import spawning it on multiple processes
Previous Message hb@101-factory.eu 2012-06-16 15:59:55 Re: any solution for doing a data file import spawning it on multiple processes