Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA09627; Wed, 31 Mar 93 09:17:12 -0800
Message-Id: <9303311717.AA09627@postgres.Berkeley.EDU>
From: Mike Olson <mao@postgres.Berkeley.EDU>
Subject: Re: Improving database load speed
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Wed, 31 Mar 1993 08:29:07 PST.
             <9303311629.AA09160@postgres.Berkeley.EDU> 
Date: Wed, 31 Mar 1993 09:17:10 -0800
From: Mike Olson <mao@postgres.Berkeley.EDU>

In message <9303311629.AA09160@postgres.Berkeley.EDU>you write:

> 1. Will using "copy" or "copy binary" improve disk access => improved
> 	speed?

yup.

> 2. Is there any other way to make the disk access more efficient?

if you don't want to use copy, you can do

	begin
	append
	append
	append 
	...
	end

which will not force a transaction commit (and synchronous disk write) for
every record added to the db.
					mike