| From: | Markus Schiltknecht <markus(at)bluegap(dot)ch> |
|---|---|
| To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: dbt2 NOTPM numbers |
| Date: | 2007-06-05 14:25:33 |
| Message-ID: | 4665725D.6060102@bluegap.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
Heikki Linnakangas wrote:
> Maybe, TPC-C is very write-intensive. I don't know much about RAID
> stuff, but I think you'd really benefit from a separate WAL drive. You
> could try turning fsync=off to see if that makes a difference.
Hm.. good idea, I'll try that.
> Oh, and how many connections are you using? DBT-2 can be quite sensitive
> to that. 30 seems to work pretty well for me.
I've been using between 2 and 90, but that made pretty much no
difference at all. I'm not getting anything more that some 300 NOTPM.
Regards
Markus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Douglas J Hunley | 2007-06-05 14:34:04 | Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x |
| Previous Message | Douglas J Hunley | 2007-06-05 14:25:14 | Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x |