Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: sniff test on some PG 8.4 numbers
Date
Msg-id 5136958F.5050508@agliodbs.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
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

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