Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL and sql-bench - Mailing list pgsql-performance

From Jim Nasby
Subject Re: PostgreSQL and sql-bench
Date
Msg-id A3838F83-CFB7-4742-AACF-49C79A8502F1@decibel.org
Whole thread Raw
In response to Re: PostgreSQL and sql-bench  (yoav x <yoav112003@yahoo.com>)
List pgsql-performance
Tree view 
On Sep 25, 2006, at 10:58 AM, yoav x wrote:
> I am not comparing Postgres to MyISAM (obviously it is not a very
> fair comparison) and we do need
> ACID, so all comparison are made against InnoDB (which now supports
> MVCC as well). I will try
> again with the suggestions posted here.

Make sure that you're not inadvertently disabling ACIDity in MySQL/
InnoDB; some options/performance tweaks will do that last I looked.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Confusion and Questions about blocks read
Next
From: "Tim Truman"
Date:
Subject: Forcing the use of particular execution plans