Re: sniff test on some PG 8.4 numbers

From: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: sniff test on some PG 8.4 numbers
Date: 2013-03-06 03:00:30
Message-ID: CAKuK5J2S1NM0ARvoAhYq8TRERTinMM5boSJKitbWZLOVygkOog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Mar 5, 2013 at 1:35 PM, Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> wrote:
>
> pgbench -h BLAH -c 32 -M prepared -t 100000 -S
> I get 95,000 to 100,000 tps.
>
> pgbench -h BLAH -c 32 -M prepared -t 100000
> seems to hover around 6,200 tps (size 100) to 13,700 (size 400)

Some followup:
The read test goes (up to) 133K tps, and the read-write test to 22k
tps when performed over localhost.

--
Jon

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Julien Cigar 2013-03-06 12:33:05 Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)
Previous Message Jon Nelson 2013-03-06 02:13:10 Re: sniff test on some PG 8.4 numbers