Skip site navigation (1) Skip section navigation (2)

Re: Profiling

From: Justin Clift <justin(at)postgresql(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Profiling
Date: 2002-12-17 04:30:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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 (, 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?

"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

In response to

pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2002-12-17 06:57:07
Subject: Re: Profiling
Previous:From: Josh BerkusDate: 2002-12-17 04:12:47
Subject: Re: Profiling

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group