Skip site navigation (1) Skip section navigation (2)

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

From: tuanhoanganh <hatuan05(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Date: 2010-12-21 03:31:59
Message-ID: AANLkTin2_X5DKMxt+nrRX1GsqoBQU8_tfzsa0VLXT_xh@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(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

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2010-12-21 03:35:29
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Previous:From: Robert HaasDate: 2010-12-20 18:57:09
Subject: Re: UNION and bad performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group