|
62 | 62 | # (change requires restart)
|
63 | 63 | #port = 5432 # (change requires restart)
|
64 | 64 | #max_connections = 100 # (change requires restart)
|
65 |
| -# Note: Increasing max_connections costs ~400 bytes of shared memory per |
66 |
| -# connection slot, plus lock space (see max_locks_per_transaction). |
67 | 65 | #superuser_reserved_connections = 3 # (change requires restart)
|
68 | 66 | #unix_socket_directories = '/tmp' # comma-separated list of directories
|
69 | 67 | # (change requires restart)
|
|
116 | 114 | #temp_buffers = 8MB # min 800kB
|
117 | 115 | #max_prepared_transactions = 0 # zero disables the feature
|
118 | 116 | # (change requires restart)
|
119 |
| -# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory |
120 |
| -# per transaction slot, plus lock space (see max_locks_per_transaction). |
121 |
| -# It is not advisable to set max_prepared_transactions nonzero unless you |
122 |
| -# actively intend to use prepared transactions. |
| 117 | +# Caution: it is not advisable to set max_prepared_transactions nonzero unless |
| 118 | +# you actively intend to use prepared transactions. |
123 | 119 | #work_mem = 1MB # min 64kB
|
124 | 120 | #maintenance_work_mem = 16MB # min 1MB
|
125 | 121 | #max_stack_depth = 2MB # min 100kB
|
|
541 | 537 | #deadlock_timeout = 1s
|
542 | 538 | #max_locks_per_transaction = 64 # min 10
|
543 | 539 | # (change requires restart)
|
544 |
| -# Note: Each lock table slot uses ~270 bytes of shared memory, and there are |
545 |
| -# max_locks_per_transaction * (max_connections + max_prepared_transactions) |
546 |
| -# lock table slots. |
547 | 540 | #max_pred_locks_per_transaction = 64 # min 10
|
548 | 541 | # (change requires restart)
|
549 | 542 |
|
|
0 commit comments