Commit39b42ec

committed

Document that max_locks_per_transaction might need to be increased for

queries on parent tables, per suggestion from Josh Berkus.

1 parentc219d9b commit39b42ecCopy full SHA for 39b42ec

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -5550,9 +5550,9 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir'`
`5550`	`5550`	`fit in the lock table. This is <emphasis>not</> the number of`
`5551`	`5551`	`rows that can be locked; that value is unlimited. The default,`
`5552`	`5552`	`64, has historically proven sufficient, but you might need to`
`5553`		`- raise this value if you haveclients 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 havequeries 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 atserver start.`
`5556`	`5556`	`</para>`
`5557`	`5557`
`5558`	`5558`	`<para>`

Comments

(0)