Re: 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.

Oh, and I forgot:

shared_buffers 4096
sort_mem 2048
wal_files 8
wal_sync_method = fdatasync

-Josh

______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