Postgres Pro
Downloads
Home   >   mailing lists

Re: sniff test on some PG 8.4 numbers - Mailing list pgsql-performance

From Jon Nelson
Subject Re: sniff test on some PG 8.4 numbers
Date
Msg-id CAKuK5J2S1NM0ARvoAhYq8TRERTinMM5boSJKitbWZLOVygkOog@mail.gmail.com
Whole thread Raw
In response to sniff test on some PG 8.4 numbers  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Responses Re: sniff test on some PG 8.4 numbers  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-performance
Tree view 
On Tue, Mar 5, 2013 at 1:35 PM, Jon Nelson <jnelson+pgsql@jamponi.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

pgsql-performance by date:

Previous
From: Jon Nelson
Date:
Subject: Re: sniff test on some PG 8.4 numbers
Next
From: Julien Cigar
Date:
Subject: Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)