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