> 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.
PostgreSQL @ Sun
In response to
pgsql-performance by date
|Next:||From: Jim Nasby||Date: 2007-07-20 04:58:35|
|Subject: 8.2 -> 8.3 performance numbers|
|Previous:||From: Tom Lane||Date: 2007-07-20 01:45:26|
|Subject: Re: User concurrency thresholding: where do I look? |