To provide support for 1C solutions, the Postgres Pro distribution includes the following built-in modules that are enabled by default and do not require additional configuration:
fasttrun — provides a transaction-unsafe
function to truncate temporary tables without growing the size of
pg_class.
fulleq — provides an additional equivalence operator for compatibility with Microsoft SQL Server.
mchar — provides additional MCHAR
and MVARCHAR data types for compatibility with
Microsoft SQL Server.
The plantuner module allows optimizing query execution plans. To configure it for 1C solutions, do the following:
Add the library name to the shared_preload_libraries
variable in the postgresql.conf file.
shared_preload_libraries = 'plantuner'
Set the plantuner.fix_empty_table parameter to on
to improve planning for recently created empty tables.
plantuner.fix_empty_table = on
The online_analyze module provides
a set of features that immediately update statistics after INSERT,
UPDATE, DELETE, SELECT INTO,
or COPY operations for the affected tables.
To configure this module, follow the steps below.
Add the library name to the shared_preload_libraries
variable in the postgresql.conf file.
shared_preload_libraries = 'online_analyze'
Enable this module.
online_analyze.enable = on
Specify the minimum number of row updates before starting online analysis.
online_analyze.threshold = 50
Specify the fraction of the table size to start online analysis.
online_analyze.scale_factor = 0.1
Execute the ANALYZE command without VERBOSE.
online_analyze.verbose = off
Enable online analysis for temporary tables.
online_analyze.table_type = 'temporary'
Specify the minimum time interval between ANALYZE
calls per table, in milliseconds.
online_analyze.min_interval = 10000