Lowering temp_buffers minimum

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Lowering temp_buffers minimum
Date: 2025-02-25 14:33:36
Message-ID: weskknhckugbdm2yt7sa2uq53xlsax67gcdkac34sanb7qpd3p@hcc2wadao5wy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I am working on writing some tests for temporary tables. One of the tests is
that we correctly handle running out of buffer pins. That's a bit more
annoying than it needs to because the minimum for temp_buffers is 100.

It seems rather odd that our minimum for temp_buffers is 100 while the minimum
for shared_buffers, which is shared across connections!, is 16.

Does anybody see a reason we shouldn't lower temp_buffers to match
shared_buffers?

Greetings,

Andres Freund

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2025-02-25 15:00:35 Re: per backend WAL statistics
Previous Message Jelte Fennema-Nio 2025-02-25 14:28:20 Re: Make query cancellation keys longer