Search PostgreSQL documentation

monetdb_fdwExtensionsExtensionsMonetDB foreign data wrapper fdw monetdb monetdb_fdw Foreign data wrappersForeign data wrappers · Extensions moneyData TypesPG18money currency amountData Types mongo_fdwExtensionsExtensionsforeign data wrapper for MongoDB access mongo_fdw Foreign data wrappersForeign data wrappers · Extensions MonitoringManual ChaptersPG1829.10. Monitoring Because logical replication is based on a similar architecture as physical streaming replication, the monitoring on a publication node is similar to monitoring of a physica…Monitoring MonitoringManual ChaptersPG18E.6.3.1.4. Monitoring Increase the logging granularity of server variable log_connections (Melanie Plageman) § This server variable was previously only boolean, which is still supported. Add…Monitoring MonitoringManual ChaptersPG1826.2.5.2. Monitoring An important health indicator of streaming replication is the amount of WAL records generated in the primary, but not yet applied in the standby. You can calculate this …Monitoring Monitoring Database ActivityManual ChaptersPG18Chapter 27. Monitoring Database Activity A database administrator frequently wonders, “What is the system doing right now?” This chapter discusses how to find that out. Several tools are ava…Monitoring Database Activity Monitoring Disk UsageManual ChaptersPG1827.6. Monitoring Disk Usage This section discusses how to monitor the disk usage of a PostgreSQL database system.Monitoring Disk Usage monitoring_roleExtensionsExtensionsSecurity-definer monitoring wrappers for a non-privileged role monitoring role security-definer monitoring_role MonitoringMonitoring · Extensions monqExtensionsExtensionsMongoDB-like query support for jsonb data jsonb mongodb query monq CompatibilityCompatibility · Extensions morpheme_funcsExtensionsExtensionsPostgreSQL extension built with pgrx; upstream metadata did not provide a specific description. japanese mecab morphology pgrx similarity morpheme_funcs Full-text searchFull-text search · Extensions moss_uuidgenExtensionsExtensionsGenerates UUIDs for moss. We use this because there was no UUID type when moss was written, and I do not want to rewrite moss to use pgsql's uuid type moss_uuidgen Functions and aggregatesFunctions and aggregates · Extensions MOVEManual ChaptersPG1841.7.3.2. MOVE MOVE [ direction { FROM | IN } ] cursor; MOVE repositions a cursor without retrieving any data. MOVE works like the FETCH command, except it only repositions the cursor and do…MOVE MOVEManual ChaptersPG18MOVE MOVE — position a cursor Synopsis MOVE [ direction ] [ FROM | IN ] cursor_name where direction can be one of: NEXT PRIOR FIRST LAST ABSOLUTE count RELATIVE count count ALL FORWARD FORWA…MOVE MOVESQL CommandsReferenceMOVE Cursors & Prepared Statements 10 position a cursor MOVE [ direction ] [ FROM | IN ] cursor_name where direction can be one of: NEXT PRIOR FIRST LAST ABSOLUTE count RELATIVE count count…SQL Commands · Cursors & Prepared Statements Moving-Aggregate ModeManual ChaptersPG1836.12.1. Moving-Aggregate Mode Aggregate functions can optionally support moving-aggregate mode, which allows substantially faster execution of aggregate functions within windows with moving…Moving-Aggregate Mode mpartmanExtensionsExtensionsModern partition manager for PostgreSQL mpartman AnalyticsAnalytics · Extensions mtmExtensionsExtensionsaggregate to find min and max mtm Functions and aggregatesFunctions and aggregates · Extensions mtreeExtensionsExtensionsMetric-space index access method derived from PostgreSQL GiST gist index metric-space mtree AI and vectorsAI and vectors · Extensions multicdr_fdwExtensionsExtensionsForeign data wrapper for reading call-detail-record file streams as external SQL tables. cdr external-data fdw sql-med multicdr_fdw Foreign data wrappersForeign data wrappers · Extensions Multicolumn IndexesManual ChaptersPG1811.3. Multicolumn Indexes An index can be defined on more than one column of a table. For example, if you have a table of this form: CREATE TABLE test2 ( major int, minor int, name varchar )…Multicolumn Indexes multicornExtensionsExtensionsFetch foreign data in Python in your PostgreSQL server. multicorn Foreign data wrappersForeign data wrappers · Extensions Multiple Identity ColumnsManual ChaptersPG18Multiple Identity Columns PostgreSQL allows a table to have more than one identity column. The standard specifies that a table can have at most one identity column. This is relaxed mainly to…Multiple Identity Columns Multiple Statements in a Simple QueryManual ChaptersPG1854.2.2.1. Multiple Statements in a Simple Query When a simple Query message contains more than one SQL statement (separated by semicolons), those statements are executed as a single transact…Multiple Statements in a Simple Query Multiple Synchronous StandbysManual ChaptersPG1826.2.8.2. Multiple Synchronous Standbys Synchronous replication supports one or more synchronous standby servers; transactions will wait until all the standby servers which are considered as…Multiple Synchronous Standbys multirangeFunctionsReferencemultirange Range/Multirange Functions And Operators 14 Returns a multirange containing just the given range. multirange ( anyrange ) → anymultirange Returns a multirange containing just the …Functions · Range/Multirange Functions And Operators multirange_minus_multiFunctionsReferencemultirange_minus_multi Range/Multirange Functions And Operators 19 Returns the non-empty multirange(s) remaining after subtracting the second multirange from the first. If the subtraction yi…Functions · Range/Multirange Functions And Operators Multivalued ResultsManual ChaptersPG18F.50.3.1. Multivalued Results The xpath_table function assumes that the results of each XPath query might be multivalued, so the number of rows returned by the function may not be the same a…Multivalued Results Multivariate MCV ListsManual ChaptersPG1814.2.2.3. Multivariate MCV Lists Another type of statistic stored for each column are most-common value lists. This allows very accurate estimates for individual columns, but may result in s…Multivariate MCV Lists Multivariate N-Distinct CountsManual ChaptersPG1869.2.2. Multivariate N-Distinct Counts A similar problem occurs with estimation of the cardinality of sets of multiple columns, such as the number of groups that would be generated by a GROU…Multivariate N-Distinct Counts Multivariate N-Distinct CountsManual ChaptersPG1814.2.2.2. Multivariate N-Distinct Counts Single-column statistics store the number of distinct values in each column. Estimates of the number of distinct values when combining more than one …Multivariate N-Distinct Counts Multivariate Statistics ExamplesManual ChaptersPG1869.2. Multivariate Statistics ExamplesMultivariate Statistics Examples multixact_member_buffersConfigurationReferencemultixact_member_buffers Resource Usage 17 Specifies the amount of shared memory to use to cache the contents of pg_multixact/members (see Table 65.1). If this value is specified without uni…Configuration · Resource Usage multixact_offset_buffersConfigurationReferencemultixact_offset_buffers Resource Usage 17 Specifies the amount of shared memory to use to cache the contents of pg_multixact/offsets (see Table 65.1). If this value is specified without uni…Configuration · Resource Usage MultixactCreationWait EventsReferenceMultixactCreation IPC 17 Waiting for a multixact creation to complete. 18 19 20 No live core occurrence is expected on the audited release. If telemetry shows it, verify the exact patch vers…Wait Events · IPC MultiXactGenWait EventsReferenceMultiXactGen LWLock 10 Waiting to read or update shared multixact state. 11 12 13 14 15 16 17 18 19 20 9.6 A brief sample is normal around short internal critical sections. Investigate when …Wait Events · LWLock MultiXactMemberBufferWait EventsReferenceMultiXactMemberBuffer LWLock 10 Waiting for I/O on a multixact_member buffer. 11 12 13 Waiting for I/O on a multixact member SLRU buffer. 14 15 16 17 18 19 20 9.6 A brief sample is normal ar…Wait Events · LWLock MultiXactMemberSLRUWait EventsReferenceMultiXactMemberSLRU LWLock 10 Waiting to read or update multixact member mappings. 11 12 13 Waiting to access the multixact member SLRU cache. 14 15 16 17 18 19 20 9.6 Brief waits occur in w…Wait Events · LWLock MultiXactOffsetBufferWait EventsReferenceMultiXactOffsetBuffer LWLock 10 Waiting for I/O on a multixact offset buffer. 11 12 13 Waiting for I/O on a multixact offset SLRU buffer. 14 15 16 17 18 19 20 9.6 A brief sample is normal ar…Wait Events · LWLock MultiXactOffsetSLRUWait EventsReferenceMultiXactOffsetSLRU LWLock 10 Waiting to read or update multixact offset mappings. 11 12 13 Waiting to access the multixact offset SLRU cache. 14 15 16 17 18 19 20 9.6 A brief sample is norm…Wait Events · LWLock