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

Re: Abnormal performance difference between Postgresand MySQL

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>,"Farhan Husain" <russoue(at)gmail(dot)com>
Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Abnormal performance difference between Postgresand MySQL
Date: 2009-02-25 22:10:36
Message-ID: 49A56D7C.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
>>> Farhan Husain <russoue(at)gmail(dot)com> wrote: 
> The machine postgres is running on has 4 GB of RAM.
 
In addition to the other suggestions, you should be sure that
effective_cache_size is set to a reasonable value, which would
probably be somewhere in the neighborhood of '3GB'.  This doesn't
affect actual RAM allocation, but gives the optimizer a rough idea how
much data is going to be kept in cache, between both the PostgreSQL
shared_memory setting and the OS cache.  It can make better choices
with more accurate information.
 
-Kevin

In response to

Responses

pgsql-performance by date

Next:From: Farhan HusainDate: 2009-02-25 22:29:31
Subject: Re: Abnormal performance difference between Postgres and MySQL
Previous:From: Farhan HusainDate: 2009-02-25 22:08:36
Subject: Re: Abnormal performance difference between Postgres and MySQL

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