Re: Query Performance SQL Server vs. Postgresql - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Query Performance SQL Server vs. Postgresql
Date
Msg-id 4CE8E4FC0200002500037C84@gw.wicourts.gov
Whole thread Raw
Responses Re: Query Performance SQL Server vs. Postgresql  (tv@fuzzy.cz)
List 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

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Query Performance SQL Server vs. Postgresql
Next
From: tv@fuzzy.cz
Date:
Subject: Re: Query Performance SQL Server vs. Postgresql