Content-Length: 262199 | pFad | http://github.com/postgrespro/postgres/commit/39b42ecb059e24bb39a62d91fe57ab7b9ca5a2f5

ED Document that max_locks_per_transaction might need to be increased for · postgrespro/postgres@39b42ec · GitHub
Skip to content

Commit 39b42ec

Browse files
committed
Document that max_locks_per_transaction might need to be increased for
queries on parent tables, per suggestion from Josh Berkus.
1 parent c219d9b commit 39b42ec

File tree

1 file changed

+3
-3
lines changed

1 file changed

+3
-3
lines changed

doc/src/sgml/config.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -5550,9 +5550,9 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir'
55505550
fit in the lock table. This is <emphasis>not</> the number of
55515551
rows that can be locked; that value is unlimited. The default,
55525552
64, has historically proven sufficient, but you might need to
5553-
raise this value if you have clients that touch many different
5554-
tables in a single transaction. This parameter can only be set at
5555-
server start.
5553+
raise this value if you have queries that touch many different
5554+
tables in a single transaction, e.g. query of a parent table with
5555+
many children. This parameter can only be set at server start.
55565556
</para>
55575557

55585558
<para>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/39b42ecb059e24bb39a62d91fe57ab7b9ca5a2f5

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy