From: Mischa Sandberg <ischamay.andbergsay@activestateway.com>
To: pgsql-performance@postgresql.org
Subject: Tryint to match Solaris-Oracle performance with directio?
Date: Fri, 17 Sep 2004 19:23:08 GMT
Message-ID: <wQG2d.66386$XP3.65429@edtnps84> (raw)
Our product (Sophos PureMessage) runs on a Postgres database.
Some of our Solaris customers have Oracle licenses, and they've
commented on the performance difference between Oracle and Postgresql
on such boxes. In-house, we've noticed the 2:1 (sometimes 5:1)
performance difference in inserting rows (mostly 2-4K), between
Postgresql on Solaris 8 and on Linux, for machines with comparable
CPU's and RAM.
These (big) customers are starting to ask, why don't we just port our
dataserver to Oracle for them? I'd like to avoid that, if possible :-)
What we can test on, in-house are leetle Sun workstations, while some of
our customers have BIG Sun iron --- so I have no means to-date to
reproduce what their bottleneck is :-( Yes, it has been recommended that
we talk to Sun about their iForce test lab ... that's in the pipe.
In the meantime, what I gather from browsing mail archives is that
postgresql on Solaris seems to get hung up on IO rather than CPU.
Furthermore, I notice that Oracle and now MySQL use directio to bypass
the system cache, when doing heavy writes to the disk; and Postgresql
does not.
Not wishing to alter backend/store/file for this test, I figured I could
get a customer to mount the UFS volume for pg_xlog with the option
"forcedirectio".
Any comment on this? No consideration of what the wal_sync_method is at
this point. Presumably it's defaulting to fdatasync on Solaris.
BTW this is Postgres 7.4.1, and our customers are Solaris 8 and 9.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ischamay.andbergsay@activestateway.com
Subject: Re: Tryint to match Solaris-Oracle performance with directio?
In-Reply-To: <wQG2d.66386$XP3.65429@edtnps84>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox