Get the App
SLTechnology News&Howtos  ›  Database  › 

PostgreSQL 10 data types and indexes

Shulou Source: shulou.com Published: 2022-06-01 10:31:13 11月16日 Update

The six commonly used index types in PostgreSQL 10 are btree,hash,gin,gist,spgist and hash. Btree and hash are the longest, and almost all data types are supported. The following data types supported for gin,gist,spgist,brin indexes are summarized as follows:

Tags: Type data index support longest commonly used Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB OPPO Reno Redmi NVidia Linux