Documentation issue: Default value of temp_buffers

Started by PG Bug reporting formabout 6 years ago2 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/runtime-config-resource.html
Description:

https://www.postgresql.org/docs/11/runtime-config-resource.html says:

------snip------
temp_buffers (integer):
Sets the maximum number of temporary buffers used by each database session
[...] The default is eight megabytes (8MB).
------snap------

Are we setting the maximum number of buffers or the maximum total size of
the buffers?

#2Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: PG Bug reporting form (#1)
Re: Documentation issue: Default value of temp_buffers

Hello,

On 2020-Apr-20, PG Doc comments form wrote:

https://www.postgresql.org/docs/11/runtime-config-resource.html says:

------snip------
temp_buffers (integer):
Sets the maximum number of temporary buffers used by each database session
[...] The default is eight megabytes (8MB).
------snap------

Are we setting the maximum number of buffers or the maximum total size of
the buffers?

Yeah, it's ambiguous. If you give it without units, it's the number of
buffers; otherwise it's the size. The docs were updated in version 12
to include this phrase: "If this value is specified without units, it is
taken as blocks, that is BLCKSZ bytes, typically 8kB."

--
�lvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services