Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql.conf recommendations - Mailing list pgsql-performance

From Johnny Tan
Subject Re: postgresql.conf recommendations
Date
Msg-id CABMVzL2QDmSzJZBa=_41dA1FuW=zdKstdHKSDVKBqPGr6AMXvg@mail.gmail.com
Whole thread Raw
In response to postgresql.conf recommendations  (Johnny Tan <johnnydtan@gmail.com>)
List pgsql-performance
Tree view
On Thu, Feb 7, 2013 at 11:16 PM, Tony Chan <tonychan@emblocsoft.com> wrote:
Hi,

May I know what is your setting for OS cache?


Tony:

Wasn't sure if you were asking me, but here's the output from "free":
# free
             total       used       free     shared    buffers     cached
Mem:     198333224  187151280   11181944          0     155512  179589612
-/+ buffers/cache:    7406156  190927068
Swap:     16777208          0   16777208 


- better to analyze large joins and sequential scan, and turn this parameter, e.g. reduce the size of  effective_cache_size in postgresql.conf and change it  for big queries.

This makes sense. We were setting it based on the tuning guideline from this page:
"Setting effective_cache_size to 1/2 of total memory would be a normal conservative setting, and 3/4 of memory is a more aggressive but still reasonable amount."

johnny 

pgsql-performance by date:

Previous
From: Johnny Tan
Date:
Subject: Re: postgresql.conf recommendations
Next
From: Scott Marlowe
Date:
Subject: Re: postgresql.conf recommendations