Use hdparm to check that your hard disks are going as fast as you expect
them to.
If you are loggin via syslog, check that syslog isn't executing a sync()
after each message. This kills performance majorly.
Use ps to see if all the memory was found and what the processor usage is.
What is the bottleneck (ram,cpu,disk or memory)
hope this helps,
On Fri, Aug 23, 2002 at 11:17:58PM -0500, Steve Lane wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.