Re: Profiling

Josh Berkus wrote:
> 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

Hi Josh,

Want to CVS checkout the latest OSDB source code (http://www.sf.net/projects/osdb), generate say a 100MB database and
do 
a multiuser test of 20 or so users on it?

:-)

Regards and best wishes,

Justin Clift


> -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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi