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
> 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.
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
Department of Computer Science
Erik Jonsson School of Engineering and Computer Science
University of Texas at Dallas
In response to
pgsql-performance by date
|Next:||From: Rodrigo E. De León Plicet||Date: 2009-02-25 20:52:40|
|Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle|
|Previous:||From: Scott Marlowe||Date: 2009-02-25 20:28:10|
|Subject: Re: Abnormal performance difference between Postgres and MySQL|