Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?

[tuanhoanganh <hatuan05@xxxxxxxxx>]

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@xxxxxxxxx> 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