Re: Abnormal performance difference between Postgres and MySQL

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Farhan Husain <russoue(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Abnormal performance difference between Postgres and MySQL
Date: 2009-02-25 21:30:00
Message-ID: 603c8f070902251330l1b273d3ah872c01a9aaed05a4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Feb 25, 2009 at 3:44 PM, Farhan Husain <russoue(at)gmail(dot)com> wrote:
> Initially, it was the default value (32MB). Later I played with that value
> thinking that it might improve the performance. But all the values resulted
> in same amount of time.

Well, if you set it back to what we consider to be a reasonable value,
rerun EXPLAIN ANALYZE, and post that plan, it might help us tell you
what to do next.

...Robert

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Farhan Husain 2009-02-25 21:32:49 Re: Abnormal performance difference between Postgres and MySQL
Previous Message Rodrigo E. De León Plicet 2009-02-25 20:52:40 Re: Benchmark comparing PostgreSQL, MySQL and Oracle