pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: LOCK TABLE & speeding up mass data loads
Date: Mon, 27 Jan 2003 15:30:39 +0530
Message-ID: <3E35509F.29103.A464C91@localhost> (raw)
In-Reply-To: <1043661264.9231.8.camel@haggis>
References: <3E354CFB.32732.A38120C@localhost>

On 27 Jan 2003 at 3:54, Ron Johnson wrote:

> On Mon, 2003-01-27 at 03:45, Shridhar Daithankar wrote:
> > 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.
> 
> Boy Scout motto: Be prepared!!  (Serves me well as a DBA.)

Goes for everything else as well..
> 
> So it takes a little longer.  In case of failure, the time would be
> more than made up.  Also, wouldn't the WAL grow hugely if many millions
> of rows were inserted in one txn?

Nops.. If WAL starts recycling, postgresql should start flishing data from WAL 
to data files. 

At any given moment, WAL will not exceed of what you have configured. They are 
just  read ahead logs most of the times intended for crash recovery. 
(Consequently it does not help setting WAL bigger than required.)

Bye
 Shridhar

--
nominal egg:	New Yorkerese for expensive.




view thread (10+ messages)  latest in thread

Message-ID: <3E35509F.29103.A464C91@localhost>
Permalink:  ../3E35509F.29103.A464C91@localhost/
Also on:    postgresql.org/message-id/3E35509F.29103.A464C91@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: shridhar_daithankar@persistent.co.in
  Subject: Re: LOCK TABLE & speeding up mass data loads
  In-Reply-To: <3E35509F.29103.A464C91@localhost>
  References: <3E354CFB.32732.A38120C@localhost> <3E35509F.29103.A464C91@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox