Postgres Pro
Downloads
Home   >   mailing lists

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

From Farhan Husain
Subject Re: Abnormal performance difference between Postgres and MySQL
Date
Msg-id 3df32b6d0902251332t3e0ea398qfd5c7d527d00539e@mail.gmail.com
Whole thread Raw
In response to Re: Abnormal performance difference between Postgres and MySQL  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Abnormal performance difference between Postgres and MySQL  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Abnormal performance difference between Postgres and MySQL  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
Tree view

On Wed, Feb 25, 2009 at 3:30 PM, Robert Haas <robertmhaas@gmail.com> wrote:
On Wed, Feb 25, 2009 at 3:44 PM, Farhan Husain <russoue@gmail.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

Right now I am running the query again with 32MB work_mem. It is taking a long time as before. However, I have kept the following values unchanged:

shared_buffers = 32MB                   # min 128kB or max_connections*16kB
                              
temp_buffers = 1024MB                   # min 800kB

Do you think I should change them to something else?

Thanks,


--
Mohammad Farhan Husain
Research Assistant
Department of Computer Science
Erik Jonsson School of Engineering and Computer Science
University of Texas at Dallas

pgsql-performance by date:

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