| From: | Marc Millas <marc(dot)millas(at)mokadb(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | shared buffers |
| Date: | 2023-08-17 15:47:34 |
| Message-ID: | CADX_1aZ8JWufd0xHTav1tJUESK3-zrijgvJJARFsa6xjxHA_eA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
to my understanding it use to be "common sense" to limit shared buffers,
maybe around 32 GB.
due to ressources consumption of managing said cache.
I would like to know if, on a v15 with 256 GB RAM, setting shared buffers
to say 96 GB would benefit large BI queries ?
Or to say it differently, what could be advantages/disadvantages of such a
setup ?
thanks
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2023-08-17 15:54:22 | Re: Re: Fatal Error : Invalid Memory alloc request size 1236252631 |
| Previous Message | Lorusso Domenico | 2023-08-17 15:43:26 | Schema renaming cascade |