From: | Steve Lane <slane(at)fmpro(dot)com> |
---|---|
To: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
Subject: | Why is pgbench suddenly slow? |
Date: | 2002-08-24 04:17:58 |
Message-ID: | B98C7326.11FA5%slane@fmpro.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello all:
I know this is a hard question to answer, but I'm seeing some behavior
that's very odd. I have a postgresql application, with a PHP interface,
running on a single server (PowerMac G4 with 512 meg of RAM and a relatively
old version of LinuxPPC). Withno one on the system, my pgbench results vary
between 70-100 tps.
I just set up a big brand new server, tons of RAM, 15KRPM drive, two
processors, the works. Then I decided to run pgbench to see how much speed
I'd gained. The result? A consistent 30-33 tps, though it scaled very well
and stayed right at that level across loads from 1 to 64 connections.
What on earth could be going on? The new server has 2G of ram and I set
aside about 512 meg for shared memory.
Any ideas?
- steve
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-08-24 04:23:13 | Re: [GENERAL] PostgreSQL 7.2.2: Security Release |
Previous Message | Marc G. Fournier | 2002-08-24 04:13:11 | Re: [GENERAL] PostgreSQL 7.2.2: Security Release |