Movatterモバイル変換

ホーム

Appendix I. ConfiguringPostgres Pro for1C Solutions
Prev	Up	Part VIII. Appendixes	Home	Next

Appendix I. ConfiguringPostgres Pro for1C Solutions

You can install and usePostgres Pro with1C solutions in a client/server model. For optimal performance and stability, modify the following settings in thepostgresql.conf configuration file ofPostgres Pro server:

Increase the maximum number of allowed concurrent connections to the database server, up to 1000 connections.1C solutions can open a large number of connections, even if not all of them are used, so it is recommended to allow not less than 500 connections.
```
max_connections = 1000
```
To ensure that temporary tables are handled correctly, modify the following parameters:
- Increase the buffer size for temporary tables:
```
temp_buffers = 32MB
```
- Increase the number of allowed locks of tables or indexes per transaction to 256:
```
max_locks_per_transaction = 256
```
  Typically,1C solutions use a lot of temporary tables. Every backend process usually contains multiple temporary tables. When closing a connection,Postgres Pro tries to drop all temporary tables in a single transaction, so this transaction may use a lot of locks. If the number of locks exceeds themax_locks_per_transaction value, the transaction will fail, leaving multiple orphaned temporary tables.
Enable backslash escapes in all strings, and switch off the warning about using the backslash escape symbol:
```
standard_conforming_strings = offescape_string_warning = off
```
Set theeffective_cache_size parameter to at least half ofRAM available on the system.Postgres Pro query optimizer performance depends on the amount of allocated RAM.
Optimize query planning using online_analyze andplantuner extensions, as follows:
- Addonline_analyze andplantuner to theshared_preload_libraries variable.
```
shared_preload_libraries = 'online_analyze, plantuner'
```
- Enable automatic analysis of temporary tables when they are modified:
```
online_analyze.table_type = 'temporary'
```
- TunePostgres Pro optimizer to improve planning for recently created empty tables:
```
plantuner.fix_empty_table = 'on'
```
- Suppress detailed messages from theonline_analyze extension:
```
online_analyze.verbose = 'off'
```

Prev	Home	Next
H.4. Extensions	Up	Appendix J. Demo Database “Airlines”

pdf epub

By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

ページ先頭