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

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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: tuanhoanganh <hatuan05(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Date: 2010-12-18 18:51:05
Message-ID: AANLkTi=4F3on8SM_qwro5F_0D2=w6SLQJ3jqJ0im6ycf@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Sat, Dec 18, 2010 at 10:15 AM, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:
> I have server computer install Windows 2008R2, PostgreSQL 9.0.1 64 bit, 8G
...
> pgbench -h 127.0.0.1 -p 5433 -U postgres -c 100  -t 10 -C  -s 10 pgbench

Why the -C option?  You are essentially benchmarking how fast you can
make new connections to the database.  Is that what you want to be
benchmarking?

If the code you anticipate using is really going to make and break
connections between every query, you should use a connection pooler.
Which means you should be benchmarking through the connection pooler,
or just leave off the -C.

Also, -t 10 is probably too small to get meaningful results.

> tps = 20.143494 (including connections establishing)
> tps = 256.630260 (excluding connections establishing)
>
> Why pgbench on my server is very low or is it common value with my server ?

Starting a new connection in PG is relatively slow, especially so on
Windows, because it involves starting and setting up a new process for
each one.

Cheers,

Jeff

In response to

Responses

pgsql-performance by date

Next:From: tuanhoanganhDate: 2010-12-18 18:57:39
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Previous:From: Kevin GrittnerDate: 2010-12-18 18:35:24
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?

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