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

Re: Query Performance SQL Server vs. Postgresql

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pavel(dot)stehule(at)gmail(dot)com>,<humairm(at)hotmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Query Performance SQL Server vs. Postgresql
Date: 2010-11-21 15:23:07
Message-ID: 4CE8E4FC0200002500037C84@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
Pavel Stehule  wrote:
> 2010/11/21 Humair Mohammed :
 
>> shared_buffers = 2

> shared_buffers = 2 ???
 
Yeah, if that's not a typo, that's a very serious misconfiguration.
 
With 8 GB of RAM in the machine, this should probably be set to
somewhere between 200 MB and 2 GB, depending on your workload and
what else is running on the machine.
 
Please read through this page and make use of the information:
 
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
 
-Kevin

Responses

pgsql-performance by date

Next:From: tvDate: 2010-11-21 15:36:25
Subject: Re: Query Performance SQL Server vs. Postgresql
Previous:From: Pavel StehuleDate: 2010-11-21 15:14:10
Subject: Re: Query Performance SQL Server vs. Postgresql

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