effective_cache_size cfg

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux