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(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