Re: LOCK TABLE & speeding up mass data loads

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: LOCK TABLE & speeding up mass data loads
Date: 2003-01-27 09:57:05
Message-ID: 3E354FC9.21573.A43098B@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 27 Jan 2003 at 15:15, Shridhar Daithankar wrote:
> IIRc, there is a hook to \copy, not the postgreSQL command copy for how many
> transactions you would like to see. I remember to have benchmarked that and
> concluded that doing copy in one transaction is the fastest way of doing it.
>
> DOn't have a postgresql installation handy, me being in linux, but this is
> definitely possible..

I am sleeping. That should have read XP rather than linux.

Grrr..

Bye
Shridhar

--
Lowery's Law: If it jams -- force it. If it breaks, it needed replacing
anyway.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2003-01-27 10:00:39 Re: LOCK TABLE & speeding up mass data loads
Previous Message Ron Johnson 2003-01-27 09:54:25 Re: LOCK TABLE & speeding up mass data loads