Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? - Mailing list pgsql-performance

From tuanhoanganh
Subject Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Date
Msg-id AANLkTin2_X5DKMxt+nrRX1GsqoBQU8_tfzsa0VLXT_xh@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
Is there any tool work on windows can open 200 connect to postgresql  and application connect to this tool to decrease time connect to PostgreSQL (because PostgreSQL start new process when have a new connect, I want this tool open and keep 200 connect to postgreSQL, my application connect to this tool instead of postgreSQL).


My server is running Windows 2008R2 and only has RAID 10 - 4 Disk
On Mon, Dec 20, 2010 at 9:24 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
P.s. here's one of my two slower slave machines.  It has dual quad
core opterons (2352 2.1GHz) and 32 Gig ram.  Controller is an Areca
1680 with 512M battery backed cache and 2 disks for pg_xlog and 12 for
the data/base directory.  Running Centos 5.4 or so.

pgbench -c 10 -t 10000 test
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
tps = 5289.941145 (including connections establishing)
tps = 5302.815418 (excluding connections establishing)

Thanks in advance

Tuan Hoang Anh

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: UNION and bad performance
Next
From: Scott Marlowe
Date:
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?