From: markir@coretech.co.nz
To: ischamay.andbergsay@activestateway.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Tryint to match Solaris-Oracle performance with
Date: Sun, 19 Sep 2004 22:04:41 +1200
Message-ID: <1095588281.29ef3c9d222ad@mail.coretech.co.nz> (raw)
In-Reply-To: <wQG2d.66386$XP3.65429@edtnps84>
References: <wQG2d.66386$XP3.65429@edtnps84>
Hi Mischa,
You probably need to determine whether the bottleneck is cpu or disk (should be
easy enough!)
Having said that, assuming your application is insert/update intensive I would
recommend:
- mount the ufs filesystems Pg uses *without* logging
- use postgresql.conf setting fsync_method=fdatasync
These changes made my Pgbench results improve by a factor or 4 (enough to catch
the big O maybe...)
Then you will need to have a look at your other postgresql.conf parameters!
(posting this file to the list might be a plan)
Cheers
Mark
Quoting Mischa Sandberg <ischamay.andbergsay@activestateway.com>:
> 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.
>
>
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: markir@coretech.co.nz, ischamay.andbergsay@activestateway.com
Subject: Re: Tryint to match Solaris-Oracle performance with
In-Reply-To: <1095588281.29ef3c9d222ad@mail.coretech.co.nz>
* 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