Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group