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

From Akos Gabriel
Subject Re: Abnormal performance difference between Postgres and MySQL
Date
Msg-id 20090226093830.490aac56@gabriel-laptop
Whole thread Raw
In response to Re: Abnormal performance difference between Postgres and MySQL  (Claus Guttesen <kometen@gmail.com>)
List pgsql-performance
Thu, 26 Feb 2009 09:00:07 +0100 -n
Claus Guttesen <kometen@gmail.com> írta:

> > 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?
>

and reindex

--
Üdvözlettel,
Gábriel Ákos
-=E-Mail :akos.gabriel@i-logic.hu|Web:  http://www.i-logic.hu=-
-=Tel/fax:+3612367353            |Mobil:+36209278894         =-

pgsql-performance by date:

Previous
From: Claus Guttesen
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL
Next
From: Farhan Husain
Date:
Subject: Re: Abnormal performance difference between Postgres and MySQL