pgsql: Remove 10% safety margin from lock manager hash table estimates - Mailing list pgsql-committers

From Heikki Linnakangas
Subject pgsql: Remove 10% safety margin from lock manager hash table estimates
Date
Msg-id E1w8iNH-002maS-15@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Remove 10% safety margin from lock manager hash table estimates

As the comment says, the hash table sizes are just estimates, but that
doesn't mean we need a "safety margin" here. hash_estimate_size()
estimates the needed size in bytes pretty accurately for the given
number of elements, so if we wanted room for more elements in the
table, we should just use larger max_table_size in the
hash_estimate_size() call.

Reviewed-by: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Reviewed-by: Matthias van de Meent <boekewurm+postgres@gmail.com>
Discussion: https://www.postgresql.org/message-id/e07be2ba-856b-4ff5-8313-8b58b6b4e4d0@iki.fi

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/3e854d2ff1a6ee1d9e0e01319ef41eb466f06c23

Modified Files
--------------
src/backend/storage/lmgr/lock.c | 5 -----
1 file changed, 5 deletions(-)


pgsql-committers by date:

Previous
From: Amit Langote
Date:
Subject: Re: pgsql: Optimize fast-path FK checks with batched index probes
Next
From: Nathan Bossart
Date:
Subject: pgsql: Refactor relation_needs_vacanalyze().