Internals//SP-GiST Indexes
  • References/Database/PostgreSQL/Internals/SP-GiST Indexes

SP-GiST is an abbreviation for space-partitioned GiST. SP-GiST supports

2025-01-10 15:47:30
Role Membership
  • References/Database/PostgreSQL/Database Roles

It is frequently convenient to group users together to ease management of privileges: that way, privileges can be granted to, or revoked from, a group as a whole. In

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

The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database

2025-01-10 15:47:30
Type Conversion: UNION, CASE, and Related Constructs
  • References/Database/PostgreSQL/Type Conversion

SQL UNION constructs must match up possibly dissimilar types to become a single result set. The resolution algorithm is applied separately to each

2025-01-10 15:47:30
pg_restore
  • References/Database/PostgreSQL/Applications

Namepg_restore -- restore a PostgreSQL database from an archive file created by pg_dump

2025-01-10 15:47:30
ALTER TEXT SEARCH DICTIONARY
  • References/Database/PostgreSQL/Commands

NameALTER TEXT SEARCH DICTIONARY -- change the definition of a text search dictionary

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
NOTIFY
  • References/Database/PostgreSQL/Commands

NameNOTIFY -- generate a notification Synopsis

2025-01-10 15:47:30
Server Configuration: Setting Parameters
  • References/Database/PostgreSQL/Server Configuration

19.1.1. Parameter Names and Values All parameter names are case-insensitive. Every parameter takes a value of one of five types:

2025-01-10 15:47:30
Internals//Physical Storage: Free Space Map
  • References/Database/PostgreSQL/Internals/Physical Storage

Each heap and index relation, except for hash indexes, has a Free Space Map (FSM) to keep track of available space in the relation. It's stored alongside the main relation

2025-01-10 15:47:30