Re: User concurrency thresholding: where do I look? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: User concurrency thresholding: where do I look?
Date
Msg-id 200707191819.13899.josh@agliodbs.com
Whole thread Raw
In response to Re: User concurrency thresholding: where do I look?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: User concurrency thresholding: where do I look?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: User concurrency thresholding: where do I look?  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
Tom, all:

> Also, have you tried watching vmstat or local equivalent to confirm that
> the machine's not starting to swap?

We're not swapping.

> Josh, what sort of workload is being tested here --- read-mostly,
> write-mostly, a mixture?

It's a TPCC-like workload, so heavy single-row updates, and the
updates/inserts are what's being measured.  For that matter, when I've seen
this before it was with heavy-write workloads and we were measuring the
number of updates/inserts and not the number of reads.

--
Josh Berkus
PostgreSQL @ Sun
San Francisco

pgsql-performance by date:

Previous
From: "Carlos H. Reimer"
Date:
Subject: Improving select peformance
Next
From: "Carlos H. Reimer"
Date:
Subject: Problems with posting