performance

From: Tom Allison <tallison(at)tacocat(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: performance
Date: 2006-02-16 01:09:54
Message-ID: 43F3D0E2.3010200@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Probably not a rare topic...

I made a little application last night to run a test:

Given a table of few fields (3)
Insert 10 million rows minimum, not a problem.
Randomly update rows, individually, as quickly as a perl script will allow for a
total number of changes up to however many I can up to 1 billion transactions.
Each update is committed immediately.
Disk is a single EIDE 7400 RPM hard drive with EXT3 journaling.
I have 1GB RAM on some kind of 32-bit AMD CPU (2.? GHz)
postgresql version 7.4 (can't upgrade yet...)

I got about 1.25 million transactions and the IO was just clobbered.
So much so I couldn't log in to the machine to kill the client job.

I have no intention on turning this machine into a hard core server, yet.
But can someone identify what might be considered the top 5 things to do in
order to keep the system from falling over.
I'm willing to take some performance hits to allow the system to keep running.
But considering how many parameters there are to fiddle with I'm reluctant to
just start twirling knobs without knowing what I'm doing.

Browse pgsql-novice by date

  From Date Subject
Next Message James A. Bowery 2006-02-16 05:11:16 Ident authentication failed without su to user
Previous Message Nils Zierath 2006-02-15 22:01:50 newst packages for ubuntu