pgpartium configuration schema

Type: object
Schema for partition maintenance. No Additional Properties

Type: object
Generate migration files. No Additional Properties

Type: string
The directory to generate migrations in.

Must be at least 1 characters long

Type: string Default: "parent's schema"
The schema for partitions.

Must be at least 1 characters long

Type: string Default: "pg_default"
The tablespace for the partitions.

Must be at least 1 characters long

Type: string Default: "partition's tablespace"
The tablespace for the indexes.

Must be at least 1 characters long

Type: object
The storage parameters for the partitions. No Additional Properties

Type: integer
The fillfactor for a table is a percentage between 10 and 100. 100 (complete packing) is the default.

Value must be greater or equal to 10 and lesser or equal to 100

Type: integer
Specifies the minimum tuple length required before we try to compress and/or move long column values into TOAST tables, and is also the target length we try to reduce the length below once toasting begins.

Value must be greater or equal to 128 and lesser or equal to 8160

Type: integer
This sets the number of workers that should be used to assist a parallel scan of a table.

Value must be greater or equal to 0

Type: boolean Default: null
Enables or disables the autovacuum daemon for a table.

Type: boolean Default: true
Enables or disables index cleanup when VACUUM is run on a table.

Type: boolean Default: true
Enables or disables vacuum to try to truncate off any empty pages at the end of a table.

Type: integer Default: 50
Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in a table.

Value must be greater or equal to 0 and lesser or equal to 2147483647

Type: number Default: 20
Specifies a fraction of a table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM

Value must be greater or equal to 0 and lesser or equal to 100

Type: integer Default: 1000
Specifies the number of inserted tuples needed to trigger a VACUUM in a table.

Value must be greater or equal to -1 and lesser or equal to 2147483647

Type: number Default: 20
Specifies a fraction of a table size to add to autovacuum_vacuum_insert_threshold when deciding whether to trigger a VACUUM.

Value must be greater or equal to 0 and lesser or equal to 100

Type: integer Default: 50
Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in a table.

Value must be greater or equal to 0 and lesser or equal to 2147483647

Type: number Default: 10
Specifies a fraction of a table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE.

Value must be greater or equal to 0 and lesser or equal to 100

Type: number Default: 2
Specifies the cost delay value that will be used in automatic VACUUM operations.

Value must be greater or equal to 0 and lesser or equal to 100

Type: integer Default: -1
Specifies the cost limit value that will be used in automatic VACUUM operations.

Value must be greater or equal to 0 and lesser or equal to 10000

Type: integer Default: 50000000
Specifies the cutoff age (in transactions) that VACUUM should use to decide whether to freeze row versions while scanning a table.

Value must be greater or equal to 0 and lesser or equal to 1000000000

Type: integer Default: 200000000
Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within a table.

Value must be greater or equal to 100000 and lesser or equal to 2000000000

Type: integer Default: 150000000
VACUUM performs an aggressive scan if a table's pg_class.relfrozenxid field has reached the age specified by this setting.

Value must be greater or equal to 0 and lesser or equal to 2000000000

Type: integer Default: 5000000
Specifies the cutoff age (in multixacts) that VACUUM should use to decide whether to replace multixact IDs with a newer transaction ID or multixact ID while scanning a table.

Value must be greater or equal to 0 and lesser or equal to 1000000000

Type: integer Default: 400000000
Specifies the maximum age (in multixacts) that a table's pg_class.relminmxid field can attain before a VACUUM operation is forced to prevent multixact ID wraparound within a table.

Value must be greater or equal to 10000 and lesser or equal to 2000000000

Type: integer Default: 150000000
VACUUM performs an aggressive scan if a table's pg_class.relminmxid field has reached the age specified by this setting.

Value must be greater or equal to 0 and lesser or equal to 2000000000

Type: integer Default: -1
Causes each action executed by autovacuum to be logged if it ran for at least the specified amount of time. Setting this to zero logs all autovacuum actions

Value must be greater or equal to -1 and lesser or equal to 2147483647

Type: boolean Default: false
Declare a table as an additional catalog table for purposes of logical replication

Type: string
The name template for the partitions.

Must be at least 1 characters long


Examples:

{table_schema}__{table_name}__YYYY_MM_DD

{table_schema}__{table_name}__YYYY_MM

Type: string
The partition interval.

Must be at least 1 characters long

Type: integer Default: 0
The number of past partitions to make.

Value must be greater or equal to 0

Type: integer Default: 0
The number of future partitions to make.

Value must be greater or equal to 0

Type: boolean Default: false
Whether to create default partition.

Type: string
The name template for the default partition.

Must be at least 1 characters long


Example:

{table_schema}__{table_name}__default

Type: string or null Default: "null"
The retention time interval to expire partitions containing data older than the given interval.

Type: boolean Default: false
Whether to detach the expired partitions first before dropping them.

Type: boolean Default: false
Whether to only detach the expired partitions.

Type: boolean Default: false
Whether to detach the expired partitions concurrently.

Type: boolean Default: false
Whether to skip overlapping partitions. Useful when switching partition intervals. It allows resolving such overlaps manually

Type: enum (of string)
The timezone to use for the generation of the migration files.

Must be one of:

  • "Africa/Abidjan"
  • "Africa/Accra"
  • "Africa/Addis_Ababa"
  • "Africa/Algiers"
  • "Africa/Asmara"
  • "Africa/Asmera"
  • "Africa/Bamako"
  • "Africa/Bangui"
  • "Africa/Banjul"
  • "Africa/Bissau"
  • "Africa/Blantyre"
  • "Africa/Brazzaville"
  • "Africa/Bujumbura"
  • "Africa/Cairo"
  • "Africa/Casablanca"
  • "Africa/Ceuta"
  • "Africa/Conakry"
  • "Africa/Dakar"
  • "Africa/Dar_es_Salaam"
  • "Africa/Djibouti"
  • "Africa/Douala"
  • "Africa/El_Aaiun"
  • "Africa/Freetown"
  • "Africa/Gaborone"
  • "Africa/Harare"
  • "Africa/Johannesburg"
  • "Africa/Juba"
  • "Africa/Kampala"
  • "Africa/Khartoum"
  • "Africa/Kigali"
  • "Africa/Kinshasa"
  • "Africa/Lagos"
  • "Africa/Libreville"
  • "Africa/Lome"
  • "Africa/Luanda"
  • "Africa/Lubumbashi"
  • "Africa/Lusaka"
  • "Africa/Malabo"
  • "Africa/Maputo"
  • "Africa/Maseru"
  • "Africa/Mbabane"
  • "Africa/Mogadishu"
  • "Africa/Monrovia"
  • "Africa/Nairobi"
  • "Africa/Ndjamena"
  • "Africa/Niamey"
  • "Africa/Nouakchott"
  • "Africa/Ouagadougou"
  • "Africa/Porto-Novo"
  • "Africa/Sao_Tome"
  • "Africa/Timbuktu"
  • "Africa/Tripoli"
  • "Africa/Tunis"
  • "Africa/Windhoek"
  • "America/Adak"
  • "America/Anchorage"
  • "America/Anguilla"
  • "America/Antigua"
  • "America/Araguaina"
  • "America/Argentina/Buenos_Aires"
  • "America/Argentina/Catamarca"
  • "America/Argentina/ComodRivadavia"
  • "America/Argentina/Cordoba"
  • "America/Argentina/Jujuy"
  • "America/Argentina/La_Rioja"
  • "America/Argentina/Mendoza"
  • "America/Argentina/Rio_Gallegos"
  • "America/Argentina/Salta"
  • "America/Argentina/San_Juan"
  • "America/Argentina/San_Luis"
  • "America/Argentina/Tucuman"
  • "America/Argentina/Ushuaia"
  • "America/Aruba"
  • "America/Asuncion"
  • "America/Atikokan"
  • "America/Atka"
  • "America/Bahia"
  • "America/Bahia_Banderas"
  • "America/Barbados"
  • "America/Belem"
  • "America/Belize"
  • "America/Blanc-Sablon"
  • "America/Boa_Vista"
  • "America/Bogota"
  • "America/Boise"
  • "America/Buenos_Aires"
  • "America/Cambridge_Bay"
  • "America/Campo_Grande"
  • "America/Cancun"
  • "America/Caracas"
  • "America/Catamarca"
  • "America/Cayenne"
  • "America/Cayman"
  • "America/Chicago"
  • "America/Chihuahua"
  • "America/Coral_Harbour"
  • "America/Cordoba"
  • "America/Costa_Rica"
  • "America/Creston"
  • "America/Cuiaba"
  • "America/Curacao"
  • "America/Danmarkshavn"
  • "America/Dawson"
  • "America/Dawson_Creek"
  • "America/Denver"
  • "America/Detroit"
  • "America/Dominica"
  • "America/Edmonton"
  • "America/Eirunepe"
  • "America/El_Salvador"
  • "America/Ensenada"
  • "America/Fort_Nelson"
  • "America/Fort_Wayne"
  • "America/Fortaleza"
  • "America/Glace_Bay"
  • "America/Godthab"
  • "America/Goose_Bay"
  • "America/Grand_Turk"
  • "America/Grenada"
  • "America/Guadeloupe"
  • "America/Guatemala"
  • "America/Guayaquil"
  • "America/Guyana"
  • "America/Halifax"
  • "America/Havana"
  • "America/Hermosillo"
  • "America/Indiana/Indianapolis"
  • "America/Indiana/Knox"
  • "America/Indiana/Marengo"
  • "America/Indiana/Petersburg"
  • "America/Indiana/Tell_City"
  • "America/Indiana/Vevay"
  • "America/Indiana/Vincennes"
  • "America/Indiana/Winamac"
  • "America/Indianapolis"
  • "America/Inuvik"
  • "America/Iqaluit"
  • "America/Jamaica"
  • "America/Jujuy"
  • "America/Juneau"
  • "America/Kentucky/Louisville"
  • "America/Kentucky/Monticello"
  • "America/Knox_IN"
  • "America/Kralendijk"
  • "America/La_Paz"
  • "America/Lima"
  • "America/Los_Angeles"
  • "America/Louisville"
  • "America/Lower_Princes"
  • "America/Maceio"
  • "America/Managua"
  • "America/Manaus"
  • "America/Marigot"
  • "America/Martinique"
  • "America/Matamoros"
  • "America/Mazatlan"
  • "America/Mendoza"
  • "America/Menominee"
  • "America/Merida"
  • "America/Metlakatla"
  • "America/Mexico_City"
  • "America/Miquelon"
  • "America/Moncton"
  • "America/Monterrey"
  • "America/Montevideo"
  • "America/Montreal"
  • "America/Montserrat"
  • "America/Nassau"
  • "America/New_York"
  • "America/Nipigon"
  • "America/Nome"
  • "America/Noronha"
  • "America/North_Dakota/Beulah"
  • "America/North_Dakota/Center"
  • "America/North_Dakota/New_Salem"
  • "America/Nuuk"
  • "America/Ojinaga"
  • "America/Panama"
  • "America/Pangnirtung"
  • "America/Paramaribo"
  • "America/Phoenix"
  • "America/Port-au-Prince"
  • "America/Port_of_Spain"
  • "America/Porto_Acre"
  • "America/Porto_Velho"
  • "America/Puerto_Rico"
  • "America/Punta_Arenas"
  • "America/Rainy_River"
  • "America/Rankin_Inlet"
  • "America/Recife"
  • "America/Regina"
  • "America/Resolute"
  • "America/Rio_Branco"
  • "America/Rosario"
  • "America/Santa_Isabel"
  • "America/Santarem"
  • "America/Santiago"
  • "America/Santo_Domingo"
  • "America/Sao_Paulo"
  • "America/Scoresbysund"
  • "America/Shiprock"
  • "America/Sitka"
  • "America/St_Barthelemy"
  • "America/St_Johns"
  • "America/St_Kitts"
  • "America/St_Lucia"
  • "America/St_Thomas"
  • "America/St_Vincent"
  • "America/Swift_Current"
  • "America/Tegucigalpa"
  • "America/Thule"
  • "America/Thunder_Bay"
  • "America/Tijuana"
  • "America/Toronto"
  • "America/Tortola"
  • "America/Vancouver"
  • "America/Virgin"
  • "America/Whitehorse"
  • "America/Winnipeg"
  • "America/Yakutat"
  • "America/Yellowknife"
  • "Antarctica/Casey"
  • "Antarctica/Davis"
  • "Antarctica/DumontDUrville"
  • "Antarctica/Macquarie"
  • "Antarctica/Mawson"
  • "Antarctica/McMurdo"
  • "Antarctica/Palmer"
  • "Antarctica/Rothera"
  • "Antarctica/South_Pole"
  • "Antarctica/Syowa"
  • "Antarctica/Troll"
  • "Antarctica/Vostok"
  • "Arctic/Longyearbyen"
  • "Asia/Aden"
  • "Asia/Almaty"
  • "Asia/Amman"
  • "Asia/Anadyr"
  • "Asia/Aqtau"
  • "Asia/Aqtobe"
  • "Asia/Ashgabat"
  • "Asia/Ashkhabad"
  • "Asia/Atyrau"
  • "Asia/Baghdad"
  • "Asia/Bahrain"
  • "Asia/Baku"
  • "Asia/Bangkok"
  • "Asia/Barnaul"
  • "Asia/Beirut"
  • "Asia/Bishkek"
  • "Asia/Brunei"
  • "Asia/Calcutta"
  • "Asia/Chita"
  • "Asia/Choibalsan"
  • "Asia/Chongqing"
  • "Asia/Chungking"
  • "Asia/Colombo"
  • "Asia/Dacca"
  • "Asia/Damascus"
  • "Asia/Dhaka"
  • "Asia/Dili"
  • "Asia/Dubai"
  • "Asia/Dushanbe"
  • "Asia/Famagusta"
  • "Asia/Gaza"
  • "Asia/Harbin"
  • "Asia/Hebron"
  • "Asia/Ho_Chi_Minh"
  • "Asia/Hong_Kong"
  • "Asia/Hovd"
  • "Asia/Irkutsk"
  • "Asia/Istanbul"
  • "Asia/Jakarta"
  • "Asia/Jayapura"
  • "Asia/Jerusalem"
  • "Asia/Kabul"
  • "Asia/Kamchatka"
  • "Asia/Karachi"
  • "Asia/Kashgar"
  • "Asia/Kathmandu"
  • "Asia/Katmandu"
  • "Asia/Khandyga"
  • "Asia/Kolkata"
  • "Asia/Krasnoyarsk"
  • "Asia/Kuala_Lumpur"
  • "Asia/Kuching"
  • "Asia/Kuwait"
  • "Asia/Macao"
  • "Asia/Macau"
  • "Asia/Magadan"
  • "Asia/Makassar"
  • "Asia/Manila"
  • "Asia/Muscat"
  • "Asia/Nicosia"
  • "Asia/Novokuznetsk"
  • "Asia/Novosibirsk"
  • "Asia/Omsk"
  • "Asia/Oral"
  • "Asia/Phnom_Penh"
  • "Asia/Pontianak"
  • "Asia/Pyongyang"
  • "Asia/Qatar"
  • "Asia/Qostanay"
  • "Asia/Qyzylorda"
  • "Asia/Rangoon"
  • "Asia/Riyadh"
  • "Asia/Saigon"
  • "Asia/Sakhalin"
  • "Asia/Samarkand"
  • "Asia/Seoul"
  • "Asia/Shanghai"
  • "Asia/Singapore"
  • "Asia/Srednekolymsk"
  • "Asia/Taipei"
  • "Asia/Tashkent"
  • "Asia/Tbilisi"
  • "Asia/Tehran"
  • "Asia/Tel_Aviv"
  • "Asia/Thimbu"
  • "Asia/Thimphu"
  • "Asia/Tokyo"
  • "Asia/Tomsk"
  • "Asia/Ujung_Pandang"
  • "Asia/Ulaanbaatar"
  • "Asia/Ulan_Bator"
  • "Asia/Urumqi"
  • "Asia/Ust-Nera"
  • "Asia/Vientiane"
  • "Asia/Vladivostok"
  • "Asia/Yakutsk"
  • "Asia/Yangon"
  • "Asia/Yekaterinburg"
  • "Asia/Yerevan"
  • "Atlantic/Azores"
  • "Atlantic/Bermuda"
  • "Atlantic/Canary"
  • "Atlantic/Cape_Verde"
  • "Atlantic/Faeroe"
  • "Atlantic/Faroe"
  • "Atlantic/Jan_Mayen"
  • "Atlantic/Madeira"
  • "Atlantic/Reykjavik"
  • "Atlantic/South_Georgia"
  • "Atlantic/St_Helena"
  • "Atlantic/Stanley"
  • "Australia/ACT"
  • "Australia/Adelaide"
  • "Australia/Brisbane"
  • "Australia/Broken_Hill"
  • "Australia/Canberra"
  • "Australia/Currie"
  • "Australia/Darwin"
  • "Australia/Eucla"
  • "Australia/Hobart"
  • "Australia/LHI"
  • "Australia/Lindeman"
  • "Australia/Lord_Howe"
  • "Australia/Melbourne"
  • "Australia/North"
  • "Australia/NSW"
  • "Australia/Perth"
  • "Australia/Queensland"
  • "Australia/South"
  • "Australia/Sydney"
  • "Australia/Tasmania"
  • "Australia/Victoria"
  • "Australia/West"
  • "Australia/Yancowinna"
  • "Brazil/Acre"
  • "Brazil/DeNoronha"
  • "Brazil/East"
  • "Brazil/West"
  • "Canada/Atlantic"
  • "Canada/Central"
  • "Canada/Eastern"
  • "Canada/Mountain"
  • "Canada/Newfoundland"
  • "Canada/Pacific"
  • "Canada/Saskatchewan"
  • "Canada/Yukon"
  • "Chile/Continental"
  • "Chile/EasterIsland"
  • "Cuba"
  • "Egypt"
  • "Eire"
  • "Etc/GMT"
  • "Etc/GMT+0"
  • "Etc/GMT+1"
  • "Etc/GMT+10"
  • "Etc/GMT+11"
  • "Etc/GMT+12"
  • "Etc/GMT+2"
  • "Etc/GMT+3"
  • "Etc/GMT+4"
  • "Etc/GMT+5"
  • "Etc/GMT+6"
  • "Etc/GMT+7"
  • "Etc/GMT+8"
  • "Etc/GMT+9"
  • "Etc/GMT-0"
  • "Etc/GMT-1"
  • "Etc/GMT-10"
  • "Etc/GMT-11"
  • "Etc/GMT-12"
  • "Etc/GMT-13"
  • "Etc/GMT-14"
  • "Etc/GMT-2"
  • "Etc/GMT-3"
  • "Etc/GMT-4"
  • "Etc/GMT-5"
  • "Etc/GMT-6"
  • "Etc/GMT-7"
  • "Etc/GMT-8"
  • "Etc/GMT-9"
  • "Etc/GMT0"
  • "Etc/Greenwich"
  • "Etc/UCT"
  • "Etc/Universal"
  • "Etc/UTC"
  • "Etc/Zulu"
  • "Europe/Amsterdam"
  • "Europe/Andorra"
  • "Europe/Astrakhan"
  • "Europe/Athens"
  • "Europe/Belfast"
  • "Europe/Belgrade"
  • "Europe/Berlin"
  • "Europe/Bratislava"
  • "Europe/Brussels"
  • "Europe/Bucharest"
  • "Europe/Budapest"
  • "Europe/Busingen"
  • "Europe/Chisinau"
  • "Europe/Copenhagen"
  • "Europe/Dublin"
  • "Europe/Gibraltar"
  • "Europe/Guernsey"
  • "Europe/Helsinki"
  • "Europe/Isle_of_Man"
  • "Europe/Istanbul"
  • "Europe/Jersey"
  • "Europe/Kaliningrad"
  • "Europe/Kiev"
  • "Europe/Kirov"
  • "Europe/Kyiv"
  • "Europe/Lisbon"
  • "Europe/Ljubljana"
  • "Europe/London"
  • "Europe/Luxembourg"
  • "Europe/Madrid"
  • "Europe/Malta"
  • "Europe/Mariehamn"
  • "Europe/Minsk"
  • "Europe/Monaco"
  • "Europe/Moscow"
  • "Europe/Nicosia"
  • "Europe/Oslo"
  • "Europe/Paris"
  • "Europe/Podgorica"
  • "Europe/Prague"
  • "Europe/Riga"
  • "Europe/Rome"
  • "Europe/Samara"
  • "Europe/San_Marino"
  • "Europe/Sarajevo"
  • "Europe/Saratov"
  • "Europe/Simferopol"
  • "Europe/Skopje"
  • "Europe/Sofia"
  • "Europe/Stockholm"
  • "Europe/Tallinn"
  • "Europe/Tirane"
  • "Europe/Tiraspol"
  • "Europe/Ulyanovsk"
  • "Europe/Uzhgorod"
  • "Europe/Vaduz"
  • "Europe/Vatican"
  • "Europe/Vienna"
  • "Europe/Vilnius"
  • "Europe/Volgograd"
  • "Europe/Warsaw"
  • "Europe/Zagreb"
  • "Europe/Zaporozhye"
  • "Europe/Zurich"
  • "GB"
  • "GB-Eire"
  • "Hongkong"
  • "Iceland"
  • "Indian/Antananarivo"
  • "Indian/Chagos"
  • "Indian/Christmas"
  • "Indian/Cocos"
  • "Indian/Comoro"
  • "Indian/Kerguelen"
  • "Indian/Mahe"
  • "Indian/Maldives"
  • "Indian/Mauritius"
  • "Indian/Mayotte"
  • "Indian/Reunion"
  • "Iran"
  • "Israel"
  • "Jamaica"
  • "Japan"
  • "Kwajalein"
  • "Libya"
  • "Mexico/BajaNorte"
  • "Mexico/BajaSur"
  • "Mexico/General"
  • "Navajo"
  • "NZ"
  • "NZ-CHAT"
  • "Pacific/Apia"
  • "Pacific/Auckland"
  • "Pacific/Bougainville"
  • "Pacific/Chatham"
  • "Pacific/Chuuk"
  • "Pacific/Easter"
  • "Pacific/Efate"
  • "Pacific/Enderbury"
  • "Pacific/Fakaofo"
  • "Pacific/Fiji"
  • "Pacific/Funafuti"
  • "Pacific/Galapagos"
  • "Pacific/Gambier"
  • "Pacific/Guadalcanal"
  • "Pacific/Guam"
  • "Pacific/Honolulu"
  • "Pacific/Johnston"
  • "Pacific/Kanton"
  • "Pacific/Kiritimati"
  • "Pacific/Kosrae"
  • "Pacific/Kwajalein"
  • "Pacific/Majuro"
  • "Pacific/Marquesas"
  • "Pacific/Midway"
  • "Pacific/Nauru"
  • "Pacific/Niue"
  • "Pacific/Norfolk"
  • "Pacific/Noumea"
  • "Pacific/Pago_Pago"
  • "Pacific/Palau"
  • "Pacific/Pitcairn"
  • "Pacific/Pohnpei"
  • "Pacific/Ponape"
  • "Pacific/Port_Moresby"
  • "Pacific/Rarotonga"
  • "Pacific/Saipan"
  • "Pacific/Samoa"
  • "Pacific/Tahiti"
  • "Pacific/Tarawa"
  • "Pacific/Tongatapu"
  • "Pacific/Truk"
  • "Pacific/Wake"
  • "Pacific/Wallis"
  • "Pacific/Yap"
  • "Poland"
  • "Portugal"
  • "PRC"
  • "ROC"
  • "Singapore"
  • "US/Alaska"
  • "US/Aleutian"
  • "US/Arizona"
  • "US/Central"
  • "US/East-Indiana"
  • "US/Eastern"
  • "US/Hawaii"
  • "US/Indiana-Starke"
  • "US/Michigan"
  • "US/Mountain"
  • "US/Pacific"
  • "US/Samoa"

Type: array of object
List of tables to run partition maintenance for.

Must contain a minimum of 1 items

No Additional Items

Each item of this array must be:

Type: object
The table to run partition maintenance for. No Additional Properties

Type: string
The schema of a table.

Must be at least 1 characters long

Type: string
The name of a table.

Must be at least 1 characters long

Type: string
The template for the migration filename. Must match regular expression: \{description\}

Must be at least 1 characters long


Examples:

V{integer}__{description}.sql

V{integer:3}__{description}.sql

{timestamp}__{description}.sql

{epoch}_{description}.up.sql

Type: object
The description of the migration. No Additional Properties

Type: string
The description for making of partitions.

Must be at least 1 characters long

Type: string
The description for expiration of partitions.

Must be at least 1 characters long

Type: object
The partition configuration for a table. No Additional Properties

Type: string Default: "parent's schema"
The schema for partitions.

Must be at least 1 characters long

Type: string Default: "pg_default"
The tablespace for the partitions.

Must be at least 1 characters long

Type: string Default: "partition's tablespace"
The tablespace for the indexes.

Must be at least 1 characters long

Type: object
The storage parameters for the partitions. No Additional Properties

Type: integer
The fillfactor for a table is a percentage between 10 and 100. 100 (complete packing) is the default.

Value must be greater or equal to 10 and lesser or equal to 100

Type: integer
Specifies the minimum tuple length required before we try to compress and/or move long column values into TOAST tables, and is also the target length we try to reduce the length below once toasting begins.

Value must be greater or equal to 128 and lesser or equal to 8160

Type: integer
This sets the number of workers that should be used to assist a parallel scan of a table.

Value must be greater or equal to 0

Type: boolean Default: null
Enables or disables the autovacuum daemon for a table.

Type: boolean Default: true
Enables or disables index cleanup when VACUUM is run on a table.

Type: boolean Default: true
Enables or disables vacuum to try to truncate off any empty pages at the end of a table.

Type: integer Default: 50
Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in a table.

Value must be greater or equal to 0 and lesser or equal to 2147483647

Type: number Default: 20
Specifies a fraction of a table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM

Value must be greater or equal to 0 and lesser or equal to 100

Type: integer Default: 1000
Specifies the number of inserted tuples needed to trigger a VACUUM in a table.

Value must be greater or equal to -1 and lesser or equal to 2147483647

Type: number Default: 20
Specifies a fraction of a table size to add to autovacuum_vacuum_insert_threshold when deciding whether to trigger a VACUUM.

Value must be greater or equal to 0 and lesser or equal to 100

Type: integer Default: 50
Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in a table.

Value must be greater or equal to 0 and lesser or equal to 2147483647

Type: number Default: 10
Specifies a fraction of a table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE.

Value must be greater or equal to 0 and lesser or equal to 100

Type: number Default: 2
Specifies the cost delay value that will be used in automatic VACUUM operations.

Value must be greater or equal to 0 and lesser or equal to 100

Type: integer Default: -1
Specifies the cost limit value that will be used in automatic VACUUM operations.

Value must be greater or equal to 0 and lesser or equal to 10000

Type: integer Default: 50000000
Specifies the cutoff age (in transactions) that VACUUM should use to decide whether to freeze row versions while scanning a table.

Value must be greater or equal to 0 and lesser or equal to 1000000000

Type: integer Default: 200000000
Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within a table.

Value must be greater or equal to 100000 and lesser or equal to 2000000000

Type: integer Default: 150000000
VACUUM performs an aggressive scan if a table's pg_class.relfrozenxid field has reached the age specified by this setting.

Value must be greater or equal to 0 and lesser or equal to 2000000000

Type: integer Default: 5000000
Specifies the cutoff age (in multixacts) that VACUUM should use to decide whether to replace multixact IDs with a newer transaction ID or multixact ID while scanning a table.

Value must be greater or equal to 0 and lesser or equal to 1000000000

Type: integer Default: 400000000
Specifies the maximum age (in multixacts) that a table's pg_class.relminmxid field can attain before a VACUUM operation is forced to prevent multixact ID wraparound within a table.

Value must be greater or equal to 10000 and lesser or equal to 2000000000

Type: integer Default: 150000000
VACUUM performs an aggressive scan if a table's pg_class.relminmxid field has reached the age specified by this setting.

Value must be greater or equal to 0 and lesser or equal to 2000000000

Type: integer Default: -1
Causes each action executed by autovacuum to be logged if it ran for at least the specified amount of time. Setting this to zero logs all autovacuum actions

Value must be greater or equal to -1 and lesser or equal to 2147483647

Type: boolean Default: false
Declare a table as an additional catalog table for purposes of logical replication

Type: string
The name template for the partitions.

Must be at least 1 characters long


Examples:

{table_schema}__{table_name}__YYYY_MM_DD

{table_schema}__{table_name}__YYYY_MM

Type: string
The partition interval.

Must be at least 1 characters long

Type: integer Default: 0
The number of past partitions to make.

Value must be greater or equal to 0

Type: integer Default: 0
The number of future partitions to make.

Value must be greater or equal to 0

Type: boolean Default: false
Whether to create default partition.

Type: string
The name template for the default partition.

Must be at least 1 characters long


Example:

{table_schema}__{table_name}__default

Type: string or null Default: "null"
The retention time interval to expire partitions containing data older than the given interval.

Type: boolean Default: false
Whether to detach the expired partitions first before dropping them.

Type: boolean Default: false
Whether to only detach the expired partitions.

Type: boolean Default: false
Whether to detach the expired partitions concurrently.

Type: boolean Default: false
Whether to skip overlapping partitions. Useful when switching partition intervals. It allows resolving such overlaps manually

Type: enum (of string)
The timezone to use for the generation of the migration files.

Must be one of:

  • "Africa/Abidjan"
  • "Africa/Accra"
  • "Africa/Addis_Ababa"
  • "Africa/Algiers"
  • "Africa/Asmara"
  • "Africa/Asmera"
  • "Africa/Bamako"
  • "Africa/Bangui"
  • "Africa/Banjul"
  • "Africa/Bissau"
  • "Africa/Blantyre"
  • "Africa/Brazzaville"
  • "Africa/Bujumbura"
  • "Africa/Cairo"
  • "Africa/Casablanca"
  • "Africa/Ceuta"
  • "Africa/Conakry"
  • "Africa/Dakar"
  • "Africa/Dar_es_Salaam"
  • "Africa/Djibouti"
  • "Africa/Douala"
  • "Africa/El_Aaiun"
  • "Africa/Freetown"
  • "Africa/Gaborone"
  • "Africa/Harare"
  • "Africa/Johannesburg"
  • "Africa/Juba"
  • "Africa/Kampala"
  • "Africa/Khartoum"
  • "Africa/Kigali"
  • "Africa/Kinshasa"
  • "Africa/Lagos"
  • "Africa/Libreville"
  • "Africa/Lome"
  • "Africa/Luanda"
  • "Africa/Lubumbashi"
  • "Africa/Lusaka"
  • "Africa/Malabo"
  • "Africa/Maputo"
  • "Africa/Maseru"
  • "Africa/Mbabane"
  • "Africa/Mogadishu"
  • "Africa/Monrovia"
  • "Africa/Nairobi"
  • "Africa/Ndjamena"
  • "Africa/Niamey"
  • "Africa/Nouakchott"
  • "Africa/Ouagadougou"
  • "Africa/Porto-Novo"
  • "Africa/Sao_Tome"
  • "Africa/Timbuktu"
  • "Africa/Tripoli"
  • "Africa/Tunis"
  • "Africa/Windhoek"
  • "America/Adak"
  • "America/Anchorage"
  • "America/Anguilla"
  • "America/Antigua"
  • "America/Araguaina"
  • "America/Argentina/Buenos_Aires"
  • "America/Argentina/Catamarca"
  • "America/Argentina/ComodRivadavia"
  • "America/Argentina/Cordoba"
  • "America/Argentina/Jujuy"
  • "America/Argentina/La_Rioja"
  • "America/Argentina/Mendoza"
  • "America/Argentina/Rio_Gallegos"
  • "America/Argentina/Salta"
  • "America/Argentina/San_Juan"
  • "America/Argentina/San_Luis"
  • "America/Argentina/Tucuman"
  • "America/Argentina/Ushuaia"
  • "America/Aruba"
  • "America/Asuncion"
  • "America/Atikokan"
  • "America/Atka"
  • "America/Bahia"
  • "America/Bahia_Banderas"
  • "America/Barbados"
  • "America/Belem"
  • "America/Belize"
  • "America/Blanc-Sablon"
  • "America/Boa_Vista"
  • "America/Bogota"
  • "America/Boise"
  • "America/Buenos_Aires"
  • "America/Cambridge_Bay"
  • "America/Campo_Grande"
  • "America/Cancun"
  • "America/Caracas"
  • "America/Catamarca"
  • "America/Cayenne"
  • "America/Cayman"
  • "America/Chicago"
  • "America/Chihuahua"
  • "America/Coral_Harbour"
  • "America/Cordoba"
  • "America/Costa_Rica"
  • "America/Creston"
  • "America/Cuiaba"
  • "America/Curacao"
  • "America/Danmarkshavn"
  • "America/Dawson"
  • "America/Dawson_Creek"
  • "America/Denver"
  • "America/Detroit"
  • "America/Dominica"
  • "America/Edmonton"
  • "America/Eirunepe"
  • "America/El_Salvador"
  • "America/Ensenada"
  • "America/Fort_Nelson"
  • "America/Fort_Wayne"
  • "America/Fortaleza"
  • "America/Glace_Bay"
  • "America/Godthab"
  • "America/Goose_Bay"
  • "America/Grand_Turk"
  • "America/Grenada"
  • "America/Guadeloupe"
  • "America/Guatemala"
  • "America/Guayaquil"
  • "America/Guyana"
  • "America/Halifax"
  • "America/Havana"
  • "America/Hermosillo"
  • "America/Indiana/Indianapolis"
  • "America/Indiana/Knox"
  • "America/Indiana/Marengo"
  • "America/Indiana/Petersburg"
  • "America/Indiana/Tell_City"
  • "America/Indiana/Vevay"
  • "America/Indiana/Vincennes"
  • "America/Indiana/Winamac"
  • "America/Indianapolis"
  • "America/Inuvik"
  • "America/Iqaluit"
  • "America/Jamaica"
  • "America/Jujuy"
  • "America/Juneau"
  • "America/Kentucky/Louisville"
  • "America/Kentucky/Monticello"
  • "America/Knox_IN"
  • "America/Kralendijk"
  • "America/La_Paz"
  • "America/Lima"
  • "America/Los_Angeles"
  • "America/Louisville"
  • "America/Lower_Princes"
  • "America/Maceio"
  • "America/Managua"
  • "America/Manaus"
  • "America/Marigot"
  • "America/Martinique"
  • "America/Matamoros"
  • "America/Mazatlan"
  • "America/Mendoza"
  • "America/Menominee"
  • "America/Merida"
  • "America/Metlakatla"
  • "America/Mexico_City"
  • "America/Miquelon"
  • "America/Moncton"
  • "America/Monterrey"
  • "America/Montevideo"
  • "America/Montreal"
  • "America/Montserrat"
  • "America/Nassau"
  • "America/New_York"
  • "America/Nipigon"
  • "America/Nome"
  • "America/Noronha"
  • "America/North_Dakota/Beulah"
  • "America/North_Dakota/Center"
  • "America/North_Dakota/New_Salem"
  • "America/Nuuk"
  • "America/Ojinaga"
  • "America/Panama"
  • "America/Pangnirtung"
  • "America/Paramaribo"
  • "America/Phoenix"
  • "America/Port-au-Prince"
  • "America/Port_of_Spain"
  • "America/Porto_Acre"
  • "America/Porto_Velho"
  • "America/Puerto_Rico"
  • "America/Punta_Arenas"
  • "America/Rainy_River"
  • "America/Rankin_Inlet"
  • "America/Recife"
  • "America/Regina"
  • "America/Resolute"
  • "America/Rio_Branco"
  • "America/Rosario"
  • "America/Santa_Isabel"
  • "America/Santarem"
  • "America/Santiago"
  • "America/Santo_Domingo"
  • "America/Sao_Paulo"
  • "America/Scoresbysund"
  • "America/Shiprock"
  • "America/Sitka"
  • "America/St_Barthelemy"
  • "America/St_Johns"
  • "America/St_Kitts"
  • "America/St_Lucia"
  • "America/St_Thomas"
  • "America/St_Vincent"
  • "America/Swift_Current"
  • "America/Tegucigalpa"
  • "America/Thule"
  • "America/Thunder_Bay"
  • "America/Tijuana"
  • "America/Toronto"
  • "America/Tortola"
  • "America/Vancouver"
  • "America/Virgin"
  • "America/Whitehorse"
  • "America/Winnipeg"
  • "America/Yakutat"
  • "America/Yellowknife"
  • "Antarctica/Casey"
  • "Antarctica/Davis"
  • "Antarctica/DumontDUrville"
  • "Antarctica/Macquarie"
  • "Antarctica/Mawson"
  • "Antarctica/McMurdo"
  • "Antarctica/Palmer"
  • "Antarctica/Rothera"
  • "Antarctica/South_Pole"
  • "Antarctica/Syowa"
  • "Antarctica/Troll"
  • "Antarctica/Vostok"
  • "Arctic/Longyearbyen"
  • "Asia/Aden"
  • "Asia/Almaty"
  • "Asia/Amman"
  • "Asia/Anadyr"
  • "Asia/Aqtau"
  • "Asia/Aqtobe"
  • "Asia/Ashgabat"
  • "Asia/Ashkhabad"
  • "Asia/Atyrau"
  • "Asia/Baghdad"
  • "Asia/Bahrain"
  • "Asia/Baku"
  • "Asia/Bangkok"
  • "Asia/Barnaul"
  • "Asia/Beirut"
  • "Asia/Bishkek"
  • "Asia/Brunei"
  • "Asia/Calcutta"
  • "Asia/Chita"
  • "Asia/Choibalsan"
  • "Asia/Chongqing"
  • "Asia/Chungking"
  • "Asia/Colombo"
  • "Asia/Dacca"
  • "Asia/Damascus"
  • "Asia/Dhaka"
  • "Asia/Dili"
  • "Asia/Dubai"
  • "Asia/Dushanbe"
  • "Asia/Famagusta"
  • "Asia/Gaza"
  • "Asia/Harbin"
  • "Asia/Hebron"
  • "Asia/Ho_Chi_Minh"
  • "Asia/Hong_Kong"
  • "Asia/Hovd"
  • "Asia/Irkutsk"
  • "Asia/Istanbul"
  • "Asia/Jakarta"
  • "Asia/Jayapura"
  • "Asia/Jerusalem"
  • "Asia/Kabul"
  • "Asia/Kamchatka"
  • "Asia/Karachi"
  • "Asia/Kashgar"
  • "Asia/Kathmandu"
  • "Asia/Katmandu"
  • "Asia/Khandyga"
  • "Asia/Kolkata"
  • "Asia/Krasnoyarsk"
  • "Asia/Kuala_Lumpur"
  • "Asia/Kuching"
  • "Asia/Kuwait"
  • "Asia/Macao"
  • "Asia/Macau"
  • "Asia/Magadan"
  • "Asia/Makassar"
  • "Asia/Manila"
  • "Asia/Muscat"
  • "Asia/Nicosia"
  • "Asia/Novokuznetsk"
  • "Asia/Novosibirsk"
  • "Asia/Omsk"
  • "Asia/Oral"
  • "Asia/Phnom_Penh"
  • "Asia/Pontianak"
  • "Asia/Pyongyang"
  • "Asia/Qatar"
  • "Asia/Qostanay"
  • "Asia/Qyzylorda"
  • "Asia/Rangoon"
  • "Asia/Riyadh"
  • "Asia/Saigon"
  • "Asia/Sakhalin"
  • "Asia/Samarkand"
  • "Asia/Seoul"
  • "Asia/Shanghai"
  • "Asia/Singapore"
  • "Asia/Srednekolymsk"
  • "Asia/Taipei"
  • "Asia/Tashkent"
  • "Asia/Tbilisi"
  • "Asia/Tehran"
  • "Asia/Tel_Aviv"
  • "Asia/Thimbu"
  • "Asia/Thimphu"
  • "Asia/Tokyo"
  • "Asia/Tomsk"
  • "Asia/Ujung_Pandang"
  • "Asia/Ulaanbaatar"
  • "Asia/Ulan_Bator"
  • "Asia/Urumqi"
  • "Asia/Ust-Nera"
  • "Asia/Vientiane"
  • "Asia/Vladivostok"
  • "Asia/Yakutsk"
  • "Asia/Yangon"
  • "Asia/Yekaterinburg"
  • "Asia/Yerevan"
  • "Atlantic/Azores"
  • "Atlantic/Bermuda"
  • "Atlantic/Canary"
  • "Atlantic/Cape_Verde"
  • "Atlantic/Faeroe"
  • "Atlantic/Faroe"
  • "Atlantic/Jan_Mayen"
  • "Atlantic/Madeira"
  • "Atlantic/Reykjavik"
  • "Atlantic/South_Georgia"
  • "Atlantic/St_Helena"
  • "Atlantic/Stanley"
  • "Australia/ACT"
  • "Australia/Adelaide"
  • "Australia/Brisbane"
  • "Australia/Broken_Hill"
  • "Australia/Canberra"
  • "Australia/Currie"
  • "Australia/Darwin"
  • "Australia/Eucla"
  • "Australia/Hobart"
  • "Australia/LHI"
  • "Australia/Lindeman"
  • "Australia/Lord_Howe"
  • "Australia/Melbourne"
  • "Australia/North"
  • "Australia/NSW"
  • "Australia/Perth"
  • "Australia/Queensland"
  • "Australia/South"
  • "Australia/Sydney"
  • "Australia/Tasmania"
  • "Australia/Victoria"
  • "Australia/West"
  • "Australia/Yancowinna"
  • "Brazil/Acre"
  • "Brazil/DeNoronha"
  • "Brazil/East"
  • "Brazil/West"
  • "Canada/Atlantic"
  • "Canada/Central"
  • "Canada/Eastern"
  • "Canada/Mountain"
  • "Canada/Newfoundland"
  • "Canada/Pacific"
  • "Canada/Saskatchewan"
  • "Canada/Yukon"
  • "Chile/Continental"
  • "Chile/EasterIsland"
  • "Cuba"
  • "Egypt"
  • "Eire"
  • "Etc/GMT"
  • "Etc/GMT+0"
  • "Etc/GMT+1"
  • "Etc/GMT+10"
  • "Etc/GMT+11"
  • "Etc/GMT+12"
  • "Etc/GMT+2"
  • "Etc/GMT+3"
  • "Etc/GMT+4"
  • "Etc/GMT+5"
  • "Etc/GMT+6"
  • "Etc/GMT+7"
  • "Etc/GMT+8"
  • "Etc/GMT+9"
  • "Etc/GMT-0"
  • "Etc/GMT-1"
  • "Etc/GMT-10"
  • "Etc/GMT-11"
  • "Etc/GMT-12"
  • "Etc/GMT-13"
  • "Etc/GMT-14"
  • "Etc/GMT-2"
  • "Etc/GMT-3"
  • "Etc/GMT-4"
  • "Etc/GMT-5"
  • "Etc/GMT-6"
  • "Etc/GMT-7"
  • "Etc/GMT-8"
  • "Etc/GMT-9"
  • "Etc/GMT0"
  • "Etc/Greenwich"
  • "Etc/UCT"
  • "Etc/Universal"
  • "Etc/UTC"
  • "Etc/Zulu"
  • "Europe/Amsterdam"
  • "Europe/Andorra"
  • "Europe/Astrakhan"
  • "Europe/Athens"
  • "Europe/Belfast"
  • "Europe/Belgrade"
  • "Europe/Berlin"
  • "Europe/Bratislava"
  • "Europe/Brussels"
  • "Europe/Bucharest"
  • "Europe/Budapest"
  • "Europe/Busingen"
  • "Europe/Chisinau"
  • "Europe/Copenhagen"
  • "Europe/Dublin"
  • "Europe/Gibraltar"
  • "Europe/Guernsey"
  • "Europe/Helsinki"
  • "Europe/Isle_of_Man"
  • "Europe/Istanbul"
  • "Europe/Jersey"
  • "Europe/Kaliningrad"
  • "Europe/Kiev"
  • "Europe/Kirov"
  • "Europe/Kyiv"
  • "Europe/Lisbon"
  • "Europe/Ljubljana"
  • "Europe/London"
  • "Europe/Luxembourg"
  • "Europe/Madrid"
  • "Europe/Malta"
  • "Europe/Mariehamn"
  • "Europe/Minsk"
  • "Europe/Monaco"
  • "Europe/Moscow"
  • "Europe/Nicosia"
  • "Europe/Oslo"
  • "Europe/Paris"
  • "Europe/Podgorica"
  • "Europe/Prague"
  • "Europe/Riga"
  • "Europe/Rome"
  • "Europe/Samara"
  • "Europe/San_Marino"
  • "Europe/Sarajevo"
  • "Europe/Saratov"
  • "Europe/Simferopol"
  • "Europe/Skopje"
  • "Europe/Sofia"
  • "Europe/Stockholm"
  • "Europe/Tallinn"
  • "Europe/Tirane"
  • "Europe/Tiraspol"
  • "Europe/Ulyanovsk"
  • "Europe/Uzhgorod"
  • "Europe/Vaduz"
  • "Europe/Vatican"
  • "Europe/Vienna"
  • "Europe/Vilnius"
  • "Europe/Volgograd"
  • "Europe/Warsaw"
  • "Europe/Zagreb"
  • "Europe/Zaporozhye"
  • "Europe/Zurich"
  • "GB"
  • "GB-Eire"
  • "Hongkong"
  • "Iceland"
  • "Indian/Antananarivo"
  • "Indian/Chagos"
  • "Indian/Christmas"
  • "Indian/Cocos"
  • "Indian/Comoro"
  • "Indian/Kerguelen"
  • "Indian/Mahe"
  • "Indian/Maldives"
  • "Indian/Mauritius"
  • "Indian/Mayotte"
  • "Indian/Reunion"
  • "Iran"
  • "Israel"
  • "Jamaica"
  • "Japan"
  • "Kwajalein"
  • "Libya"
  • "Mexico/BajaNorte"
  • "Mexico/BajaSur"
  • "Mexico/General"
  • "Navajo"
  • "NZ"
  • "NZ-CHAT"
  • "Pacific/Apia"
  • "Pacific/Auckland"
  • "Pacific/Bougainville"
  • "Pacific/Chatham"
  • "Pacific/Chuuk"
  • "Pacific/Easter"
  • "Pacific/Efate"
  • "Pacific/Enderbury"
  • "Pacific/Fakaofo"
  • "Pacific/Fiji"
  • "Pacific/Funafuti"
  • "Pacific/Galapagos"
  • "Pacific/Gambier"
  • "Pacific/Guadalcanal"
  • "Pacific/Guam"
  • "Pacific/Honolulu"
  • "Pacific/Johnston"
  • "Pacific/Kanton"
  • "Pacific/Kiritimati"
  • "Pacific/Kosrae"
  • "Pacific/Kwajalein"
  • "Pacific/Majuro"
  • "Pacific/Marquesas"
  • "Pacific/Midway"
  • "Pacific/Nauru"
  • "Pacific/Niue"
  • "Pacific/Norfolk"
  • "Pacific/Noumea"
  • "Pacific/Pago_Pago"
  • "Pacific/Palau"
  • "Pacific/Pitcairn"
  • "Pacific/Pohnpei"
  • "Pacific/Ponape"
  • "Pacific/Port_Moresby"
  • "Pacific/Rarotonga"
  • "Pacific/Saipan"
  • "Pacific/Samoa"
  • "Pacific/Tahiti"
  • "Pacific/Tarawa"
  • "Pacific/Tongatapu"
  • "Pacific/Truk"
  • "Pacific/Wake"
  • "Pacific/Wallis"
  • "Pacific/Yap"
  • "Poland"
  • "Portugal"
  • "PRC"
  • "ROC"
  • "Singapore"
  • "US/Alaska"
  • "US/Aleutian"
  • "US/Arizona"
  • "US/Central"
  • "US/East-Indiana"
  • "US/Eastern"
  • "US/Hawaii"
  • "US/Indiana-Starke"
  • "US/Michigan"
  • "US/Mountain"
  • "US/Pacific"
  • "US/Samoa"


The template table to replicate objects such as constraints, indexes, triggers from.

Type: enum (of string)
Must be one of the predefined options.

Must be one of:

  • "DEFAULT_PARTITION"
  • "LATEST_PARTITION"
  • "CURRENT_PARTITION"
Type: object
No Additional Properties

Type: string
The schema of a table.

Must be at least 1 characters long

Type: string
The name of a table.

Must be at least 1 characters long