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 AANLkTimGXmhW1AWm=ER4aU9zOpW1-JVp566GLjjaP8+D@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
No, I don't use SSL. Here is my pg_hba.conf
# IPv4 local connections:
host    all             all             0.0.0.0/0            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

On Sun, Dec 19, 2010 at 1:35 AM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
> tuanhoanganh  wrote:

> 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 ?

Those numbers look pretty low to me.  I would start with looking at
why it is taking so long to establish a TCP connection.  Are you
using SSL?  How are you authenticating?

-Kevin

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Следующее
От: tuanhoanganh
Дата:
Сообщение: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?