Profiling

Folks,

I had a request from one of the SF-PUG members that I found
interesting. She suggested that we post the specs of some of the
PostgreSQL servers that we administrate, their statistics, and some
comments on how they perform. I'll start it off with an example:

Small Cheap Workgroup Server
AMD Athalon 700mhz
256mb SDRAM
Dual 20gb 7200rpm IDE Drives (1 IBM, 1 Quantum)
with OS, Apache, XLog on 1st drive,
Postgres Database, Swap on 2nd drive
Running SuSE Linux 7.3
Apache 1.3.x
PHP 4.0.x
PostgreSQL 7.1.3
3-8 concurrent users on intranet application
with large transactions but low transaction frequency
(est. 20-300 reads and 5-80 writes per hour)
on small database (< 20,000 records combined in main tables)

Performance assessment: Adequate, reasonably fast
on selects except aggregates, commits taking 5-20 seconds
during medium activity. Same system with a Celeron 500
previously demonstrated horrible performance (often > 45 seconds
on selects) on complex queries, such as one view with
custom aggregates.

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco