|
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)
|
|
119 | 117 | #temp_buffers = 8MB # min 800kB
|
120 | 118 | #max_prepared_transactions = 0 # zero disables the feature
|
121 | 119 | # (change requires restart)
|
122 |
| -# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory |
123 |
| -# per transaction slot, plus lock space (see max_locks_per_transaction). |
124 |
| -# It is not advisable to set max_prepared_transactions nonzero unless you |
125 |
| -# actively intend to use prepared transactions. |
| 120 | +# Caution: it is not advisable to set max_prepared_transactions nonzero unless |
| 121 | +# you actively intend to use prepared transactions. |
126 | 122 | #work_mem = 4MB # min 64kB
|
127 | 123 | #maintenance_work_mem = 64MB # min 1MB
|
128 | 124 | #autovacuum_work_mem = -1 # min 1MB, or -1 to use maintenance_work_mem
|
|
573 | 569 | #deadlock_timeout = 1s
|
574 | 570 | #max_locks_per_transaction = 64 # min 10
|
575 | 571 | # (change requires restart)
|
576 |
| -# Note: Each lock table slot uses ~270 bytes of shared memory, and there are |
577 |
| -# max_locks_per_transaction * (max_connections + max_prepared_transactions) |
578 |
| -# lock table slots. |
579 | 572 | #max_pred_locks_per_transaction = 64 # min 10
|
580 | 573 | # (change requires restart)
|
581 | 574 |
|
|
0 commit comments