Re: Abnormal performance difference between Postgres and MySQL - Mailing list pgsql-performance

From Claus Guttesen
Subject Re: Abnormal performance difference between Postgres and MySQL
Date
Msg-id b41c75520902260000v51135030n11df876cb5aebd57@mail.gmail.com
Whole thread Raw
In response to Re: Abnormal performance difference between Postgres and MySQL  (Farhan Husain <russoue@gmail.com>)
Responses Re: Abnormal performance difference between Postgres and MySQL
List 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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL
Next
From: Akos Gabriel
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL