Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
| От | tuanhoanganh |
|---|---|
| Тема | Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? |
| Дата | |
| Msg-id | AANLkTin2_X5DKMxt+nrRX1GsqoBQU8_tfzsa0VLXT_xh@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? (Scott Marlowe <scott.marlowe@gmail.com>) |
| Ответы |
Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
|
| Список | 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
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:
Thanks in advance
Tuan Hoang Anh
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 teststarting vacuum...end.scaling factor: 100
transaction type: TPC-B (sort of)
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 по дате отправления: