Postgres Pro
Downloads
Home   >   mailing lists

effective_cache_size cfg - Mailing list pgsql-admin

From Ghiurea, Isabella
Subject effective_cache_size cfg
Date
Msg-id 1539626643680.56712@nrc-cnrc.gc.ca
Whole thread Raw
Responses Re: effective_cache_size cfg
Re: effective_cache_size cfg
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Celeste Mavoula
Date:
Subject: I need a support
Next
From: Scott Ribe
Date:
Subject: Re: effective_cache_size cfg