| 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: | 200212171227.07258.shridhar_daithankar@persistent.co.in |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
inserted
Throughput 200tps.
HTH
Shridhar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cory 'G' Watson | 2002-12-17 13:29:48 | Re: Profiling |
| Previous Message | Justin Clift | 2002-12-17 04:30:55 | Re: Profiling |