From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Steven Bradley <sbradley@llnl.gov>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Performance
Date: Thu, 24 Jun 1999 02:02:23 +0000
Message-ID: <377191AF.BE5F54A@alumni.caltech.edu> (raw)
References: <3.0.5.32.19990623150509.0092e990@poptop.llnl.gov>
> Is it unrealistic to expect Postgres to insert on the order of 100
> records per second on a Pentium 400 MHz/SCSI class machine running
> Linux? (Solaris on a comparable platform has about 1/2 the
> performance)
I'd expect roughly equivalent performance on different platforms. I
measured the insert performance a couple of years ago and found
roughly 50 inserts per second on my dual processor, 180MHz PPro
system, which was the same performance as I had on an Ingres
installation on a medium-speed Alpha/OSF-1 box.
Without knowing more about your memory and disk setup, I'll guess that
you can use more memory, can bump buffer size by using "-B 1024" or
something similar, and running without mandatory fsync() (use the "-F"
option). However, istm that your system should do better than 10ips
before you invoke "-F", otherwise you'll just be working around
another underlying problem/bottleneck.
Good luck.
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
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-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, sbradley@llnl.gov
Subject: Re: [INTERFACES] Performance
In-Reply-To: <377191AF.BE5F54A@alumni.caltech.edu>
* 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