Re: Re: [ADMIN] v7.1b4 bad performance - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Re: [ADMIN] v7.1b4 bad performance
Date
Msg-id 3A9644F1.9000303@tm.ee
Whole thread Raw
In response to Re: [ADMIN] v7.1b4 bad performance  (Dmitry Morozovsky <marck@rinet.ru>)
Responses Re: Re: [ADMIN] v7.1b4 bad performance  (Dave Mertens <dave@redbull.zyprexia.com>)
Re: Re: [ADMIN] v7.1b4 bad performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Re: [ADMIN] v7.1b4 bad performance  (Dmitry Morozovsky <marck@rinet.ru>)
List pgsql-hackers
Dmitry Morozovsky wrote:

> On Sun, 18 Feb 2001, Dmitry Morozovsky wrote:
>
> DM> I just done the experiment with increasing HZ to 1000 on my own machine
> DM> (PII 374). Your test program reports 2 ms instead of 20. The other side
> DM> of increasing HZ is surely more overhead to scheduler system. Anyway, it's
> DM> a bit of data to dig into, I suppose ;-)
> DM>
> DM> Results for pgbench with 7.1b4: (BTW, machine is FreeBSD 4-stable on IBM
> DM> DTLA IDE in ATA66 mode with tag queueing and soft updates turned on)

Is this unmodified pgbench or has it Hiroshi tweaked behaviour of
connecting each client to its own database, so that locking and such
does not shade the possible benefits (was it about 15% ?) of delay>1

also, IIRC Tom suggested running with at least -B 1024 if you can.

-----------------
Hannu


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Lock structures
Next
From: "Jaruwan Laongmal"
Date:
Subject: ask for help !!! (emergency case)