Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: User concurrency thresholding: where do I look?
- From: Josh Berkus <josh(at)agliodbs(dot)com>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: pgsql-performance(at)postgresql(dot)org, Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- Subject: Re: User concurrency thresholding: where do I look?
- Date: Thu, 19 Jul 2007 21:38:39 -0700
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
- Follow-Ups:
- Re: User concurrency thresholding: where do I look?
- From: Jignesh K. Shah
- Re: User concurrency thresholding: where do I look?
- References:
- User concurrency thresholding: where do I look?
- From: Josh Berkus
- Re: User concurrency thresholding: where do I look?
- From: Josh Berkus
- Re: User concurrency thresholding: where do I look?
- From: Tom Lane
- User concurrency thresholding: where do I look?
- Prev by Date: Re: User concurrency thresholding: where do I look?
- Next by Date: 8.2 -> 8.3 performance numbers
- Previous by thread: Re: User concurrency thresholding: where do I look?
- Next by thread: Re: User concurrency thresholding: where do I look?
- Indexes: