| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Dmitry Morozovsky <marck(at)rinet(dot)ru> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Schmidt, Peter" <peter(dot)schmidt(at)prismedia(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Re: v7.1b4 bad performance |
| Date: | 2001-02-23 11:09:37 |
| Message-ID: | 3A9644F1.9000303@tm.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaume Teixi | 2001-02-23 11:18:31 | |
| Previous Message | Jaume Teixi | 2001-02-23 11:04:30 | HELP: m$ access -> psql howto ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaruwan Laongmal | 2001-02-23 11:14:34 | ask for help !!! (emergency case) |
| Previous Message | Jaume Teixi | 2001-02-23 11:04:30 | HELP: m$ access -> psql howto ? |