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

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(dot)marlowe(at)gmail(dot)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