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@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco