Re: dbt2 NOTPM numbers - Mailing list pgsql-performance

From Markus Schiltknecht
Subject Re: dbt2 NOTPM numbers
Date
Msg-id 4665725D.6060102@bluegap.ch
Whole thread Raw
In response to Re: dbt2 NOTPM numbers  (Heikki Linnakangas <heikki@enterprisedb.com>)
List 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

pgsql-performance by date:

Previous
From: Douglas J Hunley
Date:
Subject: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Next
From: Douglas J Hunley
Date:
Subject: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x