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

Re: Profiling

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Profiling
Date: 2002-12-17 06:57:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Tuesday 17 December 2002 09:33 am, you 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:

OK my take.

P-II-450MHz/256MB/20GB IDE. Mandrake8.2, postgresql 7.2.x

PGBench, with 10M records/10,000 transactions/10 users.

Throughput 25tps.

Rest of the things were default. I am not too sure of details as this was more 
than 4 months back and that machine is windows now.

Same machine/Another benchmark

Banking application simulation.

Shared buffers 14000
Number of records: 100 in one table, continously updated+log table continously 
Throughput 200tps.


In response to

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


pgsql-performance by date

Next:From: Cory 'G' WatsonDate: 2002-12-17 13:29:48
Subject: Re: Profiling
Previous:From: Justin CliftDate: 2002-12-17 04:30:55
Subject: Re: Profiling

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