On 11/28/22 19:34, Justin Pryzby wrote:
In addition to setting work_mem, you can also (since v13) set
hash_mem_multiplier.
Is there any guidance on setting this? Or is it still "use the default
unless you can play around with it"?
default_toast_compression = lz4 # v14
On 11/28/22 21:59, Josh Berkus wrote:
Hey, folks:
I haven't configured a PostgreSQL server since version 11 (before
that, I did quite a few).
What's changed in terms of performance configuration since then? Have
the fundamentals of shared_buffers/work_mem/max_connections changed at
all?
On Mon, Nov 28, 2022 at 06:59:41PM -0800, Josh Berkus wrote:
> Hey, folks:
>
> I haven't configured a PostgreSQL server since version 11 (before that, I
> did quite a few).
>
> What's changed in terms of performance configuration since then? Have the
> fundamentals of
Hey, folks:
I haven't configured a PostgreSQL server since version 11 (before that,
I did quite a few).
What's changed in terms of performance configuration since then? Have
the fundamentals of shared_buffers/work_mem/max_connections changed at
all? Which new settings are must-tunes?