Re: sniff test on some PG 8.4 numbers

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: sniff test on some PG 8.4 numbers
Date: 2013-03-06 01:02:07
Message-ID: 5136958F.5050508@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> Do these basically sniff right?

Well, the read test seems reasonable. I'm impressed by the speed of the
write test ... how large is the raid card cache?

And why 8.4? Can you try 9.2?

> (NOTE: with barriers off, I get a slight increase - 10% - in the
> read-write test, and a larger *decrease* - 15% - with the read-only
> test @ 400. No change @ 100)

Oh, interesting. Can you reproduce that? I wonder what would cause
read-only to drop without barriers ...

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jon Nelson 2013-03-06 02:13:10 Re: sniff test on some PG 8.4 numbers
Previous Message Joshua D. Drake 2013-03-06 00:07:21 Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)