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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message tv 2010-11-21 15:36:25 Re: Query Performance SQL Server vs. Postgresql
Previous Message Pavel Stehule 2010-11-21 15:14:10 Re: Query Performance SQL Server vs. Postgresql