effective_cache_size cfg

From: "Ghiurea, Isabella" <Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: effective_cache_size cfg
Date: 2018-10-15 18:04:03
Message-ID: 1539626643680.56712@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello List,

I am running PGSQL 10.4 on Cent OS Pg instance has ' effective_cache_size' parameter not enabled I would like to learn what will the optimizer behavior be in this case ?

( default is set to 4GB , I was thinking PG 's optimizer will try to use all available OS RAM when trying to estimate a query, is this the case)

thank you

Isabella

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2018-10-15 20:03:11 Re: effective_cache_size cfg
Previous Message Celeste Mavoula 2018-10-15 10:51:58 I need a support