Re: Abnormal performance difference between Postgres and MySQL

From: Claus Guttesen <kometen(at)gmail(dot)com>
To: Farhan Husain <russoue(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Abnormal performance difference between Postgres and MySQL
Date: 2009-02-26 08:00:07
Message-ID: b41c75520902260000v51135030n11df876cb5aebd57@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> The execution time has not improved. I am going to increase the
> shared_buffers now keeping the work_mem same.

Have you performed a vacuum analyze?

--
regards
Claus

When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.

Shakespeare

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Akos Gabriel 2009-02-26 08:38:30 Re: Abnormal performance difference between Postgres and MySQL
Previous Message Robert Haas 2009-02-26 00:59:55 Re: Abnormal performance difference between Postgres and MySQL