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 |