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

Re: Abnormal performance difference between Postgres and MySQL

From: Farhan Husain <russoue(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Abnormal performance difference between Postgres and MySQL
Date: 2009-02-25 20:44:26
Message-ID: 3df32b6d0902251244t416c0c68p37833891bb908045@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, Feb 25, 2009 at 1:52 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> > Please note that this (1792MB) is the highest that I could set for
> work_mem.
>
> Yeah, that's almost certainly part of your problem.
>
> You need to make that number MUCH smaller.  You probably want a value
> like 1MB or 5MB or maybe if you have really a lot of memory 20MB.
>
> That's insanely high.
>
> ...Robert
>

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.

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

In response to

Responses

pgsql-performance by date

Next:From: Rodrigo E. De León PlicetDate: 2009-02-25 20:52:40
Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle
Previous:From: Scott MarloweDate: 2009-02-25 20:28:10
Subject: Re: Abnormal performance difference between Postgres and MySQL

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