Search PostgreSQL documentation

geqoConfigurationReferencegeqo Query Tuning 10 Enables or disables genetic query optimization. This is on by default. It is usually best not to turn it off in production; the geqo_threshold variable provides more gra…Configuration · Query Tuning geqo_effortConfigurationReferencegeqo_effort Query Tuning 10 Controls the trade-off between planning time and query plan quality in GEQO. This variable must be an integer in the range from 1 to 10. The default value is five…Configuration · Query Tuning geqo_extensionExtensionsExtensionsLoad-only extraction of PostgreSQL's Genetic Query Optimizer with a planner hook and configurable GEQO behavior. genetic-algorithm join-order optimizer planner-hook geqo FeaturesFeatures · Extensions geqo_generationsConfigurationReferencegeqo_generations Query Tuning 10 Controls the number of generations used by GEQO, that is the number of iterations of the algorithm. It must be at least one, and useful values are in the sam…Configuration · Query Tuning geqo_pool_sizeConfigurationReferencegeqo_pool_size Query Tuning 10 Controls the pool size used by GEQO, that is the number of individuals in the genetic population. It must be at least two, and useful values are typically 100 …Configuration · Query Tuning geqo_seedConfigurationReferencegeqo_seed Query Tuning 10 Controls the initial value of the random number generator used by GEQO to select random paths through the join order search space. The value can range from zero (th…Configuration · Query Tuning geqo_selection_biasConfigurationReferencegeqo_selection_bias Query Tuning 10 Controls the selection bias used by GEQO. The selection bias is the selective pressure within the population. Values can be from 1.50 to 2.00; the latter …Configuration · Query Tuning geqo_thresholdConfigurationReferencegeqo_threshold Query Tuning 10 Use genetic query optimization to plan queries with at least this many FROM items involved. (Note that a FULL OUTER JOIN construct counts as only one FROM item…Configuration · Query Tuning GET DESCRIPTORManual ChaptersPG18GET DESCRIPTOR GET DESCRIPTOR — get information from an SQL descriptor area Synopsis GET DESCRIPTOR descriptor_name :cvariable = descriptor_header_item GET DESCRIPTOR descriptor_name VALUE c…GET DESCRIPTOR get_bitFunctionsReferenceget_bit Binary String Functions And Operators 10 Extract bit from string get_bit ( string, offset ) → int Extract bit from string 11 12 13 Extracts n'th bit from binary string. get_bit ( byt…Functions · Binary String Functions And Operators get_byteFunctionsReferenceget_byte Binary String Functions And Operators 10 Extract byte from string get_byte ( string, offset ) → int Extract byte from string 11 12 13 Extracts n'th byte from binary string. get_byte…Functions · Binary String Functions And Operators get_columnExtensionsExtensionsFetch a column value from a record by name column dynamic extension record row utility get_column Functions and aggregatesFunctions and aggregates · Extensions get_current_ts_configFunctionsReferenceget_current_ts_config Text Search Functions And Operators 10 get default text search configuration get_current_ts_config ( ) → regconfig get default text search configuration 11 12 13 Return…Functions · Text Search Functions And Operators get_sumExtensionsExtensionssimple sum of two integers for postgres externsion using c get_sum Functions and aggregatesFunctions and aggregates · Extensions getdatabaseencodingFunctionsReferencegetdatabaseencoding String Functions And Operators 20 Returns current database encoding name. getdatabaseencoding ( ) → name Returns current database encoding name.Functions · String Functions And Operators Getting StartedManual ChaptersPG18Chapter 1. Getting StartedGetting Started Getting the SourceManual ChaptersPG1817.2. Getting the Source The PostgreSQL source code for released versions can be obtained from the download section of our website: https://www.postgresql.org/ftp/source/. Download the postg…Getting the Source Getting the Source via GitManual ChaptersPG18I.1. Getting the Source via Git With Git you will make a copy of the entire code repository on your local machine, so you will have access to all history and branches offline. This is the fa…Getting the Source via Git gevelExtensionsExtensionsIndex-inspection functions for GiST, GIN, SP-GiST, B-tree, and BRIN indexes. brin btree gin gist index-inspection sp-gist gevel AdministrationAdministration · Extensions gfsExtensionsExtensionsGFS copy-on-read storage: a Table Access Method whose missing rows are fetched from the source on read and written through locally agentic-ai agents clickhouse database mcp mysql postgresql …Replication and streams · Extensions gg_tables_trackingExtensionsExtensionsGreengage relation-size change tracking for monitoring and maintenance. greengage relation-size tracking monitoring greengage MonitoringMonitoring · Extensions gg_wait_samplingExtensionsExtensionsGreengage wait-event sampling with history and query attribution. greengage wait-event sampling monitoring greengage MonitoringMonitoring · Extensions ginExtensionsPG1865.4. GIN IndexesGIN Indexes GINManual ChaptersPG1811.2.5. GIN GIN indexes are “inverted indexes” which are appropriate for data values that contain multiple component values, such as arrays. An inverted index contains a separate entry for e…GIN GIN Fast Update TechniqueManual ChaptersPG1865.4.4.1. GIN Fast Update Technique Updating a GIN index tends to be slow because of the intrinsic nature of inverted indexes: inserting or updating one heap row can cause many inserts into …GIN Fast Update Technique GIN FunctionsManual ChaptersPG18F.23.5. GIN Functions gin_metapage_info(page bytea) returns record gin_metapage_info returns information about a GIN index metapage. For example: test=# SELECT * FROM gin_metapage_info(get_r…GIN Functions GIN IndexesManual ChaptersPG1865.4. GIN IndexesGIN Indexes GIN Tips and TricksManual ChaptersPG1865.4.5. GIN Tips and Tricks Create vs. insert Insertion into a GIN index can be slow due to the likelihood of many keys being inserted for each item. So, for bulk insertions into a table it …GIN Tips and Tricks gin_clean_pending_listFunctionsReferencegin_clean_pending_list System Administration Functions 10 move GIN pending list entries into main index structure gin_clean_pending_list ( index regclass ) → bigint move GIN pending list ent…Functions · System Administration Functions gin_fuzzy_search_limitConfigurationReferencegin_fuzzy_search_limit Client Connection Defaults 10 Soft upper limit of the size of the set returned by GIN index scans. For more information see Section 64.5. 11 Soft upper limit of the si…Configuration · Client Connection Defaults gin_pending_list_limitConfigurationReferencegin_pending_list_limit Client Connection Defaults 10 Sets the maximum size of the GIN pending list which is used when fastupdate is enabled. If the list grows larger than this maximum size, …Configuration · Client Connection Defaults gis_objectsExtensionsExtensionsPostgres extension for Point, Polygon, and Point-in-Polygon operations in C c gis postgresql-extension sql gis_objects GeospatialGeospatial · Extensions gistExtensionsPG1865.2. GiST IndexesGiST Indexes GiSTManual ChaptersPG1811.2.3. GiST GiST indexes are not a single kind of index, but rather an infrastructure within which many different indexing strategies can be implemented. Accordingly, the particular operato…GiST GiST FunctionsManual ChaptersPG18F.23.6. GiST Functions gist_page_opaque_info(page bytea) returns record gist_page_opaque_info returns information from a GiST index page's opaque area, such as the NSN, rightlink and page ty…GiST Functions GiST Index Build MethodsManual ChaptersPG1865.2.4.1. GiST Index Build Methods The simplest way to build a GiST index is just to insert all the entries, one by one. This tends to be slow for large indexes, because if the index tuples …GiST Index Build Methods GiST IndexesManual ChaptersPG1865.2. GiST IndexesGiST Indexes git_fdwExtensionsExtensionsPostgreSQL Git Foreign Data Wrapper fdw git git_fdw Foreign data wrappersForeign data wrappers · Extensions gitgresExtensionsExtensionsStore Git objects and refs in PostgreSQL tables with SQL functions and a native git_oid type. git libgit2 object-storage version-control gitgres FeaturesFeatures · Extensions gliaExtensionsExtensionsA PostgreSQL extension for data mining. analytics data data-mining mining glia AI and vectorsAI and vectors · Extensions