Re: postgresql-performance using sysbench
- From: Ivan Voras <ivoras@xxxxxxxxxxx>
- Date: Thu, 31 Jan 2008 21:16:18 +0100
Niki Denev wrote:
HZ=1000
Time:
239 seconds total
122 seconds of transactions (4 per second)
What do you think?
This is a very low result :) I don't know your machine or the parameters you used with postmark but even FreeBSD on two striped 7.5 kRPM drives can achieve ~~ 110 tps (so ~~ 50 for a single drive). In the same circumstances and with the right file system - reiserfs in this case - Linux can achieve close to 900 tps (170 tps with ext3). This is the kind of difference I am talking about. A change of 4 tps to 6 tps is not generally useful.
Attachment:
signature.asc
Description: OpenPGP digital signature
- Follow-Ups:
- Re: postgresql-performance using sysbench
- From: Niki Denev
- Re: postgresql-performance using sysbench
- References:
- postgresql-performance using sysbench
- From: Claus Guttesen
- Re: postgresql-performance using sysbench
- From: Claus Guttesen
- Re: postgresql-performance using sysbench
- From: Kris Kennaway
- Re: postgresql-performance using sysbench
- From: Claus Guttesen
- Re: postgresql-performance using sysbench
- From: Ivan Voras
- Re: postgresql-performance using sysbench
- From: Claus Guttesen
- Re: postgresql-performance using sysbench
- From: Kris Kennaway
- Re: postgresql-performance using sysbench
- From: Ivan Voras
- Re: postgresql-performance using sysbench
- From: Kris Kennaway
- Re: postgresql-performance using sysbench
- From: Ivan Voras
- Re: postgresql-performance using sysbench
- From: Niki Denev
- postgresql-performance using sysbench
- Prev by Date: Re: newfs + gstat locks entire machine for 20seconds
- Next by Date: Re: postgresql-performance using sysbench
- Previous by thread: Re: postgresql-performance using sysbench
- Next by thread: Re: postgresql-performance using sysbench
- Index(es):