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 200707192138.39679.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?  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
List pgsql-performance
Tom,

> Well, if the load is a lot of short writing transactions then you'd
> expect the throughput to depend on how fast stuff can be pushed down to
> WAL.  What have you got wal_buffers set to?  Are you using a commit
> delay?  What's the I/O system anyway (any BB write cache on the WAL
> disk?) and what wal sync method are you using?

You know, I think Jignesh needs to me on this list so I can stop relaying
questions on a workload I didn't design.  Let me get him.

--
Josh Berkus
PostgreSQL @ Sun
San Francisco

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: User concurrency thresholding: where do I look?
Next
From: Jim Nasby
Date:
Subject: 8.2 -> 8.3 performance numbers