Thread: Re: Query Performance SQL Server vs. Postgresql

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

> 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.

I guess that's a typo, as the explain plain in one of the previous posts
contains

   Buffers: shared hit=192 read=4833

for a sequential scan. But I still don't know why is the query so slow :-(

regards
Tomas