Re: PostgreSQL and sql-bench

From: Jim Nasby <decibel(at)decibel(dot)org>
To: yoav x <yoav112003(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL and sql-bench
Date: 2006-09-27 03:28:41
Message-ID: A3838F83-CFB7-4742-AACF-49C79A8502F1@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim Nasby 2006-09-27 03:42:16 Re: Decreasing BLKSZ
Previous Message Jim Nasby 2006-09-27 03:21:11 Re: IN not handled very well?