hi there,
I am trying to import large data files into pg.
for now i used the. xarg linux command to spawn the file line for line and set
and use the maximum available connections.
we use pg pool as connection pool to the database, and so try to maximize the
concurrent data import of the fil
Em 16/06/2012 12:04, h...@101-factory.eu escreveu:
hi there,
I am trying to import large data files into pg.
for now i used the. xarg linux command to spawn the file line for line and set
and use the maximum available connections.
we use pg pool as connection pool to the database, and so try
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
henk
h...@101-factory.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?
>
>
Em 16/06/2012 12:59, h...@101-factory.eu escreveu:
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 co
Hello all,
Would someone please point me to (or supply) some working examples of
UPDATE commands using the WITH clause syntax as described in the manual
(pdf version page 1560) and referring to Section 7.8 (pdf version page 104)?
I have looked around a lot and haven't seen much on this.
I have a
On 2012-06-16 19:11, Bill House wrote:
Would someone please point me to (or supply) some working examples of
UPDATE commands using the WITH clause syntax as described in the manual
(pdf version page 1560) and referring to Section 7.8 (pdf version page 104)?
http://www.depesz.com/2011/03/16/wait
thanks all, i will be looking into it.
Met vriendelijke groet,
Henk
On 16 jun. 2012, at 18:23, Edson Richter wrote:
> Em 16/06/2012 12:59, h...@101-factory.eu escreveu:
>> thanks i thought about splitting the file, but that did no work out well.
>>
>> so we receive 2 files evry 30 seconds a
On Jun 16, 2012, at 1:11 PM, Bill House wrote:
> md5sum may be duplicated and I am trying to mark the column "del" of the
> redundant records leaving one unmarked.
>
> Here is one variation of the syntax I have tried on one group:
>
> WITH batch AS (select * from files_test where
>
On 06/16/2012 01:27 PM, Vibhor Kumar wrote:
> On Jun 16, 2012, at 1:11 PM, Bill House wrote:
>
>> md5sum may be duplicated and I am trying to mark the column "del" of the
>> redundant records leaving one unmarked.
>>
>> Here is one variation of the syntax I have tried on one group:
>>
>> WITH
10 matches
Mail list logo
