Performance
Jason <neumeier@bright.net>
From: Jason <neumeier@bright.net>
To: "'psql'" <pgsql-general@postgresql.org>
Cc: "Aaron Holtz (E-mail)" <aholtz@bright.net>
Date: 1999-03-30T13:36:16Z
Lists: pgsql-general
Looking for a little reasoning behind our performance difference on 2 different platforms. We have been running postgres on our sparcs, and have come to rely on the dB quite heavily. We have dedicated a box to doing nothing but our postgres work. Here is what we have: Dual Sparc 167 512 MB RAM Solaris 2.5.1 Performance seemed reasonable to us, until we ran the same database and queries on the following machine: Intel Celeron 333 128 MB RAM Red Hat Linux 5.2 We have a passwd style database with 65,000 rows. We updated 20,000 of them with a SQL update command, setting a single integer field to a value. Both boxes where indexed the same, and had identical data. The Sparc took near 10 minutes to complete, while the Intel took ~30 seconds. This is just one case, but many very similar tests had the same results. Now I love Linux, and the price compared to a Sparc makes it much simpler to get one on line. However, I can't understand why the Sparc would lag so far behind. We are starting Postgres the same on both machines: su - postgres -c "/usr/local/pgsql/bin/postmaster -B 256 -o -F -i -S" We are looking at getting a dual 400 Intel Pentium II box with Red Hat to migrate all of the Postgres work to. But in the meantime, is there a way to optimize the performance on the Sparc? Thanks in advance. -Jason Neumeier.