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

Re: Profiling

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Profiling
Date: 2002-12-17 04:12:47
Message-ID: web-2284500@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

  • Profiling at 2002-12-17 04:03:51 from Josh Berkus

Responses

pgsql-performance by date

Next:From: Justin CliftDate: 2002-12-17 04:30:55
Subject: Re: Profiling
Previous:From: Josh BerkusDate: 2002-12-17 04:03:51
Subject: Profiling

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