Internals//GIN Indexes: Examples
  • References/Database/PostgreSQL/Internals/GIN Indexes

The PostgreSQL source distribution includes GIN operator classes for tsvector

2025-01-10 15:47:30
intagg
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The intagg module provides an integer aggregator and an enumerator. intagg is now obsolete, because there are built-in

2025-01-10 15:47:30
Upgrading a PostgreSQL Cluster
  • References/Database/PostgreSQL/Server Setup and Operation

This section discusses how to upgrade your database data from one PostgreSQL release to a newer one.

2025-01-10 15:47:30
Catalogs: pg_ts_config
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser

2025-01-10 15:47:30
EXPLAIN
  • References/Database/PostgreSQL/Commands

NameEXPLAIN -- show the execution plan of a statement Synopsis

2025-01-10 15:47:30
Monetary Types
  • References/Database/PostgreSQL/Data Types

The money type stores a currency amount with a fixed fractional precision; see Table 8-3. The fractional precision is determined by the database's

2025-01-10 15:47:30
Arrays
  • References/Database/PostgreSQL/Data Types

PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base

2025-01-10 15:47:30
Starting the Database Server
  • References/Database/PostgreSQL/Server Setup and Operation

Before anyone can access the database, you must start the database server. The database server program is called postgres. The

2025-01-10 15:47:30
CREATE TYPE
  • References/Database/PostgreSQL/Commands

NameCREATE TYPE -- define a new data type Synopsis

2025-01-10 15:47:30
DROP MATERIALIZED VIEW
  • References/Database/PostgreSQL/Commands

NameDROP MATERIALIZED VIEW -- remove a materialized view Synopsis

2025-01-10 15:47:30