Routine Reindexing
  • References/Database/PostgreSQL/Maintenance

In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command or a series

2025-01-10 15:47:30
ROLLBACK TO SAVEPOINT
  • References/Database/PostgreSQL/Commands

NameROLLBACK TO SAVEPOINT -- roll back to a savepoint Synopsis

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

NameCREATE OPERATOR -- define a new operator Synopsis

2025-01-10 15:47:30
Internals//Genetic Query Optimizer: Further Reading
  • References/Database/PostgreSQL/Internals/Genetic Query Optimizer

The following resources contain additional information about genetic algorithms:

2025-01-10 15:47:30
2.
  • References/Database/PostgreSQL/Tutorial/Getting Started

Before we proceed, you should understand the basic PostgreSQL system architecture. Understanding how the parts of PostgreSQL

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

NameCREATE TABLE -- define a new table Synopsis

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

bloom provides an index access method based on Bloom filters

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

The catalog pg_shseclabel stores security labels on shared database objects. Security labels can be manipulated with the

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

NameDROP AGGREGATE -- remove an aggregate function Synopsis

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

Geometric data types represent two-dimensional spatial objects. Table 8-20 shows the geometric types available in PostgreSQL.

2025-01-10 15:47:30