pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dave Cramer <pg@fastcrypt.com>
To: Andreas Åkre Solberg <Andreas.Solberg@uninett.no>
Cc: pgsql-performance@postgresql.org, vivek singh <sing_vivek@yahoo.com>
Subject: Re: Insertion puzzles
Date: Sat, 13 Nov 2004 11:54:56 -0500
Message-ID: <41963C60.8000608@fastcrypt.com> (raw)
In-Reply-To: <4909EB74-3578-11D9-8406-000393BAA290@uninett.no>
References: <20041113112609.18083.qmail@web10703.mail.yahoo.com>
	<4909EB74-3578-11D9-8406-000393BAA290@uninett.no>

Well, the default configuration for postgresql 7.1.3 is *very* 
conservative. ( ie. very slow)

You should seriously consider upgrading to 7.4.6 as server performance 
has increased; in some cases significantly.

If that is not an option, certainly tuning the shared buffers, and 
effective cache settings would be advisable.

dave

Andreas Åkre Solberg wrote:

>
> On Nov 13, 2004, at 12:26, vivek singh wrote:
>
>>  But
>> still, with large volume of data in database the
>> insert operation becomes very slow (ie. to insert 100
>> records in 5 tables, it takes nearly 3minutes).
>
>
> What are the performance when you use COPY FROM instead of INSERT ?
> And have you tested the performance with fsync on and off.
>

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561




view thread (8+ messages)  latest in thread

Message-ID: <41963C60.8000608@fastcrypt.com>
Permalink:  ../41963C60.8000608@fastcrypt.com/
Also on:    postgresql.org/message-id/41963C60.8000608@fastcrypt.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pg@fastcrypt.com, Andreas.Solberg@uninett.no, sing_vivek@yahoo.com
  Subject: Re: Insertion puzzles
  In-Reply-To: <41963C60.8000608@fastcrypt.com>

* 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