Chapter 11. Indexes

KB at your finger tips

This is one stop global knowledge base where you can learn about all the products, solutions and support features.

Database-PostgreSQL

Chapter 11. Indexes

Table of Contents

11.1. Introduction

11.2. Index Types

11.2.1. B-Tree
11.2.2. Hash
11.2.3. GiST
11.2.4. SP-GiST
11.2.5. GIN
11.2.6. BRIN

11.3. Multicolumn Indexes

11.4. Indexes and ORDER BY

11.5. Combining Multiple Indexes

11.6. Unique Indexes

11.7. Indexes on Expressions

11.8. Partial Indexes

11.9. Index-Only Scans and Covering Indexes

11.10. Operator Classes and Operator Families

11.11. Indexes and Collations

11.12. Examining Index Usage

Indexes are a common way to enhance database performance. An index allows the database server to find and retrieve specific rows much faster than it could do without an index. But indexes also add overhead to the database system as a whole, so they should be used sensibly.

Stay Ahead in Today’s Competitive Market!
Unlock your company’s full potential with a Virtual Delivery Center (VDC). Gain specialized expertise, drive seamless operations, and scale effortlessly for long-term success.

Book A Meeting To Setup A VDC

Chapter 11. Indexes

Table of Contents

11.1. Introduction

11.2. Index Types

11.2.1. B-Tree
11.2.2. Hash
11.2.3. GiST
11.2.4. SP-GiST
11.2.5. GIN
11.2.6. BRIN

11.3. Multicolumn Indexes

11.4. Indexes and ORDER BY

11.5. Combining Multiple Indexes

11.6. Unique Indexes

11.7. Indexes on Expressions

11.8. Partial Indexes

11.9. Index-Only Scans and Covering Indexes

11.10. Operator Classes and Operator Families

11.11. Indexes and Collations

11.12. Examining Index Usage

Read article

3.7. Conclusion

PostgreSQL has many features not touched upon in this tutorial introduction, which has been oriented toward newer users of SQL . These features are discussed in more detail in the remainder of this book.

If you feel you need more introductory material, please visit the PostgreSQL web site for links to more resources.

Read article

3.7. Conclusion

If you feel you need more introductory material, please visit the PostgreSQL web site for links to more resources.

Read article

53.59. pg_ts_config

53.59. `pg_ts_config`

The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser and a list of dictionaries to use for each of the parser's output token types. The parser is shown in the pg_ts_config entry, but the token-to-dictionary mapping is defined by subsidiary entries in pg_ts_config_map .

PostgreSQL 's text search features are described at length in Chapter 12.

Table 53.59. pg_ts_config Columns

Column Type Description
`oid` `oid` Row identifier
`cfgname` `name` Text search configuration name
`cfgnamespace` `oid` (references `pg_namespace` . `oid` ) The OID of the namespace that contains this configuration
`cfgowner` `oid` (references `pg_authid` . `oid` ) Owner of the configuration
`cfgparser` `oid` (references `pg_ts_parser` . `oid` ) The OID of the text search parser for this configuration

Column Type

Description

oid oid

Row identifier

cfgname name

Text search configuration name

cfgnamespace oid (references pg_namespace . oid )

The OID of the namespace that contains this configuration

cfgowner oid (references pg_authid . oid )

Owner of the configuration

cfgparser oid (references pg_ts_parser . oid )

The OID of the text search parser for this configuration

Read article

53.59. pg_ts_config

53.59. `pg_ts_config`

PostgreSQL 's text search features are described at length in Chapter 12.

Table 53.59. pg_ts_config Columns

Column Type Description
`oid` `oid` Row identifier
`cfgname` `name` Text search configuration name
`cfgnamespace` `oid` (references `pg_namespace` . `oid` ) The OID of the namespace that contains this configuration
`cfgowner` `oid` (references `pg_authid` . `oid` ) Owner of the configuration
`cfgparser` `oid` (references `pg_ts_parser` . `oid` ) The OID of the text search parser for this configuration

Column Type

Description

oid oid

Row identifier

cfgname name

Text search configuration name

cfgnamespace oid (references pg_namespace . oid )

The OID of the namespace that contains this configuration

cfgowner oid (references pg_authid . oid )

Owner of the configuration

cfgparser oid (references pg_ts_parser . oid )

The OID of the text search parser for this configuration

Read article

Welcome to Knowledge Base!

KB at your finger tips

Database-PostgreSQL

Chapter 11. Indexes

Chapter 11. Indexes

Chapter 11. Indexes

Chapter 11. Indexes

3.7. Conclusion

3.7. Conclusion

3.7. Conclusion

3.7. Conclusion

53.59. pg_ts_config

53.59. `pg_ts_config`

53.59. pg_ts_config

53.59. `pg_ts_config`

Thank you for subscribing to AiDOOS! Stay connected for updates!