|
61 | 61 | # defaults to'localhost'; use'*'for all |
62 | 62 | # (changerequires restart) |
63 | 63 | port =5432# (changerequires restart) |
64 | | -max_connections =200# (changerequires restart) |
| 64 | +max_connections =30# (changerequires restart) |
65 | 65 | # Note: Increasing max_connections costs ~400 bytes of shared memory per |
66 | 66 | # connection slot, plus lockspace (see max_locks_per_transaction). |
67 | 67 | #superuser_reserved_connections =3# (changerequires restart) |
|
624 | 624 |
|
625 | 625 | # Add settingsfor extensions here |
626 | 626 |
|
627 | | -multimaster.workers=8 |
628 | | -multimaster.queue_size=104857600 # 100mb |
629 | | -multimaster.ignore_tables_without_pk=1 |
| 627 | +#multimaster.workers=8 |
| 628 | +#multimaster.queue_size=104857600 # 100mb |
| 629 | +#multimaster.ignore_tables_without_pk=1 |
| 630 | + |
| 631 | +listen_addresses='*' |
| 632 | +max_prepared_transactions =100 |
| 633 | +synchronous_commit = off |
| 634 | +wal_level = logical |
| 635 | +max_worker_processes =15 |
| 636 | +max_replication_slots =10 |
| 637 | +max_wal_senders =10 |
| 638 | +shared_preload_libraries ='raftable,multimaster' |
| 639 | +default_transaction_isolation ='repeatable read' |
| 640 | +log_checkpoints = on |
| 641 | +log_autovacuum_min_duration =0 |
| 642 | + |
| 643 | +multimaster.workers =4 |
| 644 | +multimaster.use_raftable =true |
| 645 | +multimaster.queue_size=52857600 |
| 646 | +multimaster.ignore_tables_without_pk =1 |
| 647 | +multimaster.heartbeat_recv_timeout =1000 |
| 648 | +multimaster.heartbeat_send_timeout =250 |
| 649 | +multimaster.twopc_min_timeout =40000 |
| 650 | + |