pgPedia

An encyclopedia (work-in-progress) of things PostgreSQL-related. And some hacks.

A

Abbreviations and acronyms
ABORT
adminpack
Advisory locking
allow_system_table_mods
ALTER AGGREGATE
ALTER COLLATION
ALTER CONVERSION
ALTER DATABASE
ALTER DEFAULT PRIVILEGES
ALTER DOMAIN
ALTER EVENT TRIGGER
ALTER EXTENSION
ALTER FOREIGN DATA WRAPPER
ALTER FOREIGN TABLE
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER LARGE OBJECT
ALTER MATERIALIZED VIEW
ALTER OPERATOR
ALTER OPERATOR CLASS
ALTER OPERATOR FAMILY
ALTER POLICY
ALTER PROCEDURE
ALTER PUBLICATION
ALTER ROLE
ALTER ROUTINE
ALTER RULE
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER STATISTICS
ALTER SUBSCRIPTION
ALTER SYSTEM
ALTER TABLE
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TEXT SEARCH PARSER
ALTER TEXT SEARCH TEMPLATE
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER USER MAPPING
ALTER VIEW
amcheck
ANALYZE
application_name
archive_cleanup_command
archive_command
archive_mode
archive_timeout
Array
ARRAY[]
array_agg()
array_append()
array_cat()
array_dims()
array_fill()
array_length()
array_lower()
array_ndims()
array_nulls
array_position()
array_positions()
array_prepend()
array_remove()
array_replace()
array_to_json()
array_to_string()
array_to_tsvector()
array_upper()
ascii()
AsciiDoc
auth_delay
auto_explain
autovacuum_vacuum_cost_delay
autovacuum_vacuum_insert_scale_factor
autovacuum_vacuum_insert_threshold
autovacuum_work_mem

B

Background worker
Background writer
backtrace_functions
Backup block
Backup history file
backup_label
Barman
BEGIN
bit_and()
bit_length()
bit_or()
bit_xor()
Block Range Index (BRIN)
block_size
bloom
bool_and()
bool_or()
bool_plperlu
brin (test module)
btree_gin
btree_gist
btrim()
bytea
bytea_output

C

CALL
cardinality()
Cascading replication
Catalog version number
cfbot
check_function_bodies
check_password_hook
Checkpoint
CHECKPOINT
checkpoint_completion_target
Checkpointer
checkpoint_flush_after
checkpoint_timeout
checkpoint_warning
check_postgres
chr()
citext
ClientAuthentication_hook
client_connection_check_interval
client_encoding
clock_timestamp()
CLUSTER
clusterdb
cluster_name
col_description()
Command tag
COMMENT ON
COMMIT
commit_delay
CommitFest
Commit log (CLOG)
COMMIT PREPARED
commit_ts
Common Table Expression (CTE)
compute_query_id
config_file
Connection Service File
conninfo
Contrib module
COPY
Core utility
CREATE ACCESS METHOD
CREATE AGGREGATE
CREATE CAST
CREATE COLLATION
CREATE CONVERSION
CREATE DATABASE
createdb
CREATE DOMAIN
CREATE EVENT TRIGGER
CREATE EXTENSION
CREATE FOREIGN DATA WRAPPER
CREATE FOREIGN TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE LANGUAGE
CREATE MATERIALIZED VIEW
CREATE OPERATOR
CREATE OPERATOR CLASS
CREATE OPERATOR FAMILY
CREATE POLICY
CREATE PROCEDURE
CREATE PUBLICATION
CREATE ROLE
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE STATISTICS
CREATE SUBSCRIPTION
CREATE TABLE
CREATE TABLE AS
CREATE TABLESPACE
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TEXT SEARCH PARSER
CREATE TEXT SEARCH TEMPLATE
CREATE TRANSFORM
CREATE TRIGGER
CREATE TYPE
create_upper_paths_hook
createuser
CREATE USER
CREATE USER MAPPING
CREATE VIEW
CSV
CSV log format
cube
current_catalog
current_database()
current_date
current_schema
current_schema()
current_schemas()
current_setting()
current_time
current_timestamp
CVS

D

Database system identifier
data_checksums
data_directory
data_directory_mode
Data page checksums
date_bin()
DBD::Pg
dblink
deadlock_timeout
debug_assertions
debug_discard_caches
debug_pretty_print
debug_print_parse
debug_print_plan
debug_print_rewritten
decode()
Default role
default_table_access_method
default_tablespace
default_toast_compression
default_transaction_read_only
default_with_oids
dict_int
dict_xsyn
Direct I/O
DISCARD
DO
DocBook XML
Domain
DROP ACCESS METHOD
DROP AGGREGATE
DROP CAST
DROP COLLATION
DROP CONVERSION
DROP DATABASE
dropdb
DROP DOMAIN
DROP EVENT TRIGGER
DROP EXTENSION
DROP FOREIGN DATA WRAPPER
DROP FOREIGN TABLE
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MATERIALIZED VIEW
DROP OPERATOR
DROP OPERATOR CLASS
DROP OPERATOR FAMILY
DROP OWNED
DROP POLICY
DROP PROCEDURE
DROP PUBLICATION
DROP ROLE
DROP ROUTINE
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP STATISTICS
DROP SUBSCRIPTION
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TEXT SEARCH PARSER
DROP TEXT SEARCH TEMPLATE
DROP TRANSFORM
DROP TRIGGER
DROP TYPE
dropuser
DROP USER
DROP USER MAPPING
DROP VIEW
DUAL table
dummy_index_am
dummy_seclabel
dynamic_library_path

E

earthdistance
ECPG
effective_cache_size
effective_io_concurrency
emit_log_hook
enable_incrementalsort
enable_parallel_insert
enable_partition_pruning
enable_partitionwise_aggregate
enable_partitionwise_join
encode()
END
ENUM
EOL (End of Life)
Event trigger
ExecutorCheckPerms_hook
ExecutorEnd_hook
ExecutorFinish_hook
ExecutorRun_hook
ExecutorStart_hook
exit_on_error
EXPLAIN
explain_get_index_name_hook
ExplainOneQuery_hook
Extension
external_pid_file
extract()

F

factorial()
fallback_application_name
file_fdw
filenode
firebird_fdw
fmgr_hook
Foreign Data Wrapper (FDW)
Foreign keys
Foreign table
Fork
format_type()
Frontend/Backend Protocol
full_page_writes
Full text search
func_beg
func_end
func_setup
fuzzystrmatch

G

gcd()
Generated column
generate_series()
generate_subscripts()
gen_random_uuid()
get_attavgwidth_hook
get_index_stats_hook
get_relation_info_hook
get_relation_stats_hook
GIN (Generalized Inverted Index)
GIT
GRANT
GUC - Grand Unified Configuration

H

has_any_column_privilege()
has_column_privilege()
has_database_privilege()
has_foreign_data_wrapper_privilege()
has_function_privilege()
hash_mem_multiplier
has_language_privilege()
has_schema_privilege()
has_sequence_privilege()
has_server_privilege()
has_table_privilege()
has_tablespace_privilege()
has_type_privilege()
Hook
hot_standby
hstore
hstore_plperl
hstore_plpython
huge_pages
HypoPG

I

IDENTIFY_SYSTEM
idle_in_transaction_session_timeout
idle_session_timeout
ignore_checksum_failure
ignore_invalid_pages
ignore_system_indexes
IMPORT FOREIGN SCHEMA
include
include_dir
include_if_exists
inet_client_addr()
inet_client_port()
inet_server_addr()
inet_server_port()
Information schema
in_hot_standby
initcap()
initdb
Initialization fork
intagg
intarray
integer_datetimes
isn
Isolation tester

J

JDBC
jit
jit_provider
join_collapse_limit
join_search_hook
jsonb_typeof()
json_typeof()
justify_days()
justify_hours()
justify_interval()

K

kNN (k Nearest-Neighbour)
krb_caseins_users
krb_server_keyfile

L

Large object
lcm()
length()
libpgcommon
libpq
LISTEN
lo
LOAD
local_preload_libraries
LOCK
lock_timeout
lo_compat_privileges
lo_from_bytea()
log_checkpoints
log_connections
log_destination
log_directory
log_error_verbosity
lo_get()
log_executor_stats
log_file_mode
logging_collector
logical_decoding_work_mem
login_hook
log_line_prefix
log_lock_waits
log_min_duration_sample
log_min_duration_statement
log_parameter_max_length
log_parameter_max_length_on_error
log_parser_stats
log_planner_stats
log_statement_sample_rate
log_statement_stats
log_transaction_sample_rate
lo_put()
lower()
lpad()
LSN - Log Sequence Number
ltree
ltrim()

M

maintenance_io_concurrency
maintenance_work_mem
make_date()
make_interval()
make_time()
make_timestamp()
make_timestamptz()
max_connections
max_files_per_process
max_function_args
max_identifier_length
max_index_keys
max_locks_per_transaction
max_parallel_workers
max_parallel_workers_per_gather
max_prepared_transactions
max_replication_slots
max_slot_wal_keep_size
max_standby_archive_delay
max_standby_streaming_delay
max_wal_senders
max_wal_size
max_worker_processes
md5()
min_parallel_relation_size
min_scale()
min_wal_size
MobilityDB
multirange
Multixact ID
mysql_fdw

N

NAMEDATALEN
needs_fmgr_hook
NOTIFY
numeric
numeric_fac()

O

obj_description()
object_access_hook
Object Identifier Type
octet_length()
OID
oid2name
old_snapshot
openssl_tls_init_hook
operator_precedence_warning
ora2pg
oracle_fdw
orafce

P

pageinspect
parallel_workers
parse_ident()
passwordcheck
password_encryption
Patroni
pause_at_recovery_target
pgAdmin
pgAdmin III
pgAgent
pg_aggregate
pgagroal
pg_alterckey
pg_am
pg_amcheck
pg_amop
pg_amproc
pg_archivecleanup
pg_attrdef
pg_attribute
pgAudit
pg_authid
pg_auth_members
pg_available_extensions
pg_available_extension_versions
pg_backend_memory_contexts
pg_backend_pid()
pg_basebackup
pgbench
pg_bigm
pg_blocking_pids()
PgBouncer
pgbouncer_fdw
pg_buffercache
pg_bulkload
pg_cancel_backend()
pg_cast
pg_char_to_encoding()
pg_checksums
pg_class
pg_client_encoding()
pg_clog
pg_collation
pg_column_compression()
pg_column_size()
pg_config
pg_config (view)
pg_conf_load_time()
pg_constraint
pg_control
pg_control_checkpoint()
pg_controldata
pg_control_init()
pg_control_recovery()
pg_control_system()
pg_conversion
pg_copy_logical_replication_slot()
pg_copy_physical_replication_slot()
pg_create_logical_replication_slot()
pg_create_physical_replication_slot()
pg_create_restore_point()
pg_cron
pgcrypto
pg_ctl
pg_current_logfile()
pg_current_wal_lsn()
pg_cursors
pg_database
pg_database_size()
pg_db_role_setting
pg_default_acl
pg_depend
pg_describe_object()
pg_description
pg_dirtyread
pg_drop_replication_slot()
pg_dump
pg_dumpall
pg_encoding_to_char()
pg_enum
pgenv
pg_event_trigger
pg_extension
pg_extension_config_dump()
pg_extension_update_paths()
pg_filedump
pg_filenode.map
pg_filenode_relation()
pg_file_settings
pg_foreign_data_wrapper
pg_foreign_server
pg_foreign_table
pg_format (pgFormatter)
pg_freespacemap
pg_get_constraintdef()
pg_get_function_arguments()
pg_get_functiondef()
pg_get_function_identity_arguments()
pg_get_function_result()
pg_get_indexdef()
pg_get_object_address()
pg_get_serial_sequence()
pg_get_userbyid()
pg_get_wal_replay_pause_state()
pg_group
pg_has_role()
pg_hba.conf
pg_hba_file_rules
pg_hint_plan
pg_identify_object()
pg_index
pg_indexes
pg_indexes_size()
pg_inherits
pg_init_privs
pg_internal.init
pg_is_in_recovery()
pg_is_other_temp_schema()
pg_isready
pg_jit_available()
pg_language
pg_largeobject
pg_largeobject_metadata
pg_last_committed_xact()
pg_last_wal_receive_lsn()
pg_last_wal_replay_lsn()
pg_listening_channels()
pg_locks
pg_log_backend_memory_contexts()
pglogical
pg_logical_slot_get_binary_changes()
pg_logical_slot_get_changes()
pg_logical_slot_peek_binary_changes()
pg_logical_slot_peek_changes()
pg_ls_archive_statusdir()
pg_ls_dir()
pg_ls_logdir()
pg_lsn
pg_ls_tmpdir()
pg_ls_waldir()
pg_matviews
pg_my_temp_schema()
pg_namespace
pg_node_tree
pg_notification_queue_usage()
pg_notify()
pg_opclass
pg_operator
pg_opfamily
pg_options_to_table()
pg_partition_ancestors()
pg_partitioned_table
pg_partition_root()
pg_partition_tree()
pg_partman
pg_pltemplate
pg_policies
pg_policy
Pgpool-II
pg_postmaster_start_time()
pg_prepared_statements
pg_prepared_xacts
pg_prewarm
pg_proc
pg_promote()
pg_publication
pg_publication_rel
pg_publication_tables
pg_range
pg_read_binary_file()
pg_read_file()
pg_receivewal
pg_recvlogical
pg_relation_check_pages()
pg_relation_filenode()
pg_relation_filepath()
pg_relation_size()
pg_reload_conf()
pg_repack
pg_replay
pg_replication_origin
pg_replication_origin_status
pg_replication_slot_advance()
pg_replication_slots
pg_resetwal
pg_restore
pg_rewind
pg_rewrite
pg_roles
pg_rotate_logfile()
pgrowlocks
pg_rules
pg_seclabel
pg_seclabels
pg_sequence
pg_sequences
pg_service.conf
pg_settings
pg_shadow
pg_shdepend
pg_shdescription
pg_shmem_allocations
pg_shseclabel
pg_size_bytes()
pg_size_pretty()
pg_sleep()
pg_sleep_for()
pg_sleep_until()
pg_snakeoil
pgsql-hackers
pg_standby
pg_start_backup()
pg_stat_activity
pg_stat_all_indexes
pg_stat_all_tables
pg_stat_archiver
pg_stat_bgwriter
pg_stat_database
pg_stat_database_conflicts
pg_statement_rollback
pg_stat_file()
pg_stat_get_backend_activity()
pg_stat_get_backend_activity_start()
pg_stat_get_backend_client_addr()
pg_stat_get_backend_client_port()
pg_stat_get_backend_dbid()
pg_stat_get_backend_idset()
pg_stat_get_backend_pid()
pg_stat_get_backend_start()
pg_stat_get_backend_userid()
pg_stat_get_backend_wait_event()
pg_stat_get_backend_wait_event_type()
pg_stat_get_backend_xact_start()
pg_stat_gssapi
pg_statio_all_indexes
pg_statio_all_sequences
pg_statio_all_tables
pg_statio_sys_indexes
pg_statio_sys_sequences
pg_statio_sys_tables
pg_statio_user_indexes
pg_statio_user_sequences
pg_statio_user_tables
pg_statistic
pg_statistic_ext
pg_statistic_ext_data
pg_stat_prefetch_recovery
pg_stat_progress_analyze
pg_stat_progress_basebackup
pg_stat_progress_cluster
pg_stat_progress_copy
pg_stat_progress_create_index
pg_stat_progress_vacuum
pg_stat_replication
pg_stat_replication_slots
pg_stat_reset()
pg_stat_reset_replication_slot()
pg_stat_reset_shared()
pg_stat_reset_single_function_counters()
pg_stat_reset_single_table_counters()
pg_stats
pg_stats_ext
pg_stats_ext_exprs
pg_stat_slru
pg_stat_ssl
pg_stat_statements
pg_stat_subscription
pg_stat_sys_indexes
pg_stat_sys_tables
pgstattuple
pg_stat_user_functions
pg_stat_user_indexes
pg_stat_user_tables
pg_stat_wal
pg_stat_wal_receiver
pg_stat_xact_all_tables
pg_stat_xact_sys_tables
pg_stat_xact_user_functions
pg_stat_xact_user_tables
pg_stop_backup()
pg_subscription
pg_subscription_rel
pg_surgery
pg_switch_wal()
pg_tables
pg_table_size()
pg_tablespace
pg_tablespace_databases()
pg_tablespace_location()
pg_tablespace_size()
pg_terminate_backend()
pg_test_fsync
pg_test_timing
pg_timetable
pg_timezone_abbrevs
pg_timezone_names
pgtop
pg_top
pg_total_relation_size()
pg_transform
pg_trgm
pg_trigger
pg_trigger_depth()
pg_ts_config
pg_ts_config_map
pg_ts_dict
pg_ts_parser
pg_ts_template
pgtt - PostgreSQL Global Temporary Tables
pg_type
pg_upgrade
pg_user
pg_user_mapping
pg_user_mappings
pg_verifybackup
pg_verify_checksums
PG_VERSION (file)
pg_views
pg_visibility
pg_wait_for_backend_termination()
pg_wal
pg_waldump
pg_walfile_name()
pg_walfile_name_offset()
pg_wal_lsn_diff()
pg_wal_replay_pause()
pg_wal_replay_resume()
pg_xact
pg_xact_commit_timestamp()
pg_xlog
PGXN
PGXS
PHP
phpPgAdmin
plan_cache_mode
Planet PostgreSQL
planner_hook
PL/Java
PL/Perl
PL/Python
PL/R
PL/Sample
PLV8
PostGIS
postgres database
postgres_fdw
postgresql.auto.conf
postgresql.conf
PostgreSQL License
PostgreSQL Weekly News
PostgreSQL wiki
Postgres-XL
Postico
postmaster.opts
postmaster.pid
post_parse_analyze_hook
PREPARE TRANSACTION
primary_conninfo
primary_slot_name
Privilege
Procedural language
ProcessUtility_hook
Progress reporting
psql
.psqlrc / psqlrc
psycopg2

Q

quote_all_identifiers
quote_ident()
quote_literal()
quote_nullable()

R

REASSIGN OWNED
recovery.conf
recovery_end_command
recovery_min_apply_delay
recovery_prefetch
recovery_prefetch_fpw
recovery_target_action
Recursive query
REDO record
REDO WAL file
REFRESH MATERIALIZED VIEW
regexp_count()
regexp_instr()
regexp_like()
regexp_match()
regexp_matches()
regexp_replace()
regexp_split_to_array()
regexp_split_to_table()
regexp_substr()
REINDEX
reindexdb
RELEASE SAVEPOINT
repeat()
replace()
repmgr
RESET
restart_after_crash
Restartpoint
restore_command
ROLLBACK
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
row_security_policy_hook_permissive
row_security_policy_hook_restrictive
rpad()
rtrim()

S

SAVEPOINT
scale()
SECURITY LABEL
seg
segment_size
SELECT INTO
sepgsql
Sequence relation
server_encoding
Server Programming Interface (SPI)
Server utility
server_version
server_version_num
session_preload_libraries
SET
set_config()
set_join_pathlist_hook
set_rel_pathlist_hook
SET TRANSACTION
sha224()
sha256()
sha384()
sha512()
shared_memory_size
shared_memory_size_in_huge_pages
shared_preload_libraries
shmem_startup_hook
shobj_description()
SHOW
Slash command
smgr
snapshot_too_old
sort_mem
spi
split_part()
sqlite_fdw
SQL/MED
sslinfo
ssl_passphrase_command
ssl_passphrase_command_supports_reload
standby_mode
standby.signal
start-scripts
starts_with()
START TRANSACTION
statement_timeout
statement_timestamp()
Statistics collector
stmt_beg
stmt_end
Storage parameters
string_to_array()
string_to_table()
strpos()
substr()
superuser_reserved_connections
suppress_redundant_updates_trigger
synchronous_commit
System catalogue

T

TABLE
tablefunc
Tablespace
Tablespace directory
tablespace_map
TAP test
target_session_attrs
tcn
temp_buffers
temp_tablespaces
test_bloomfilter
test_ddl_deparse
test_decoding
test_extensions
test_ginpostinglist
test_integerset
test_misc
Test module
test_parser
test_pg_dump
test_predtest
test_rbtree
test_rls_hooks
test_shm_mq
TimescaleDB
to_ascii()
to_char()
to_date()
to_hex()
to_number()
Torn page
to_timestamp()
to_tsquery()
track_activity_query_size
track_commit_timestamp
track_counts
track_functions
track_io_timing
track_wal_io_timing
transaction_timestamp()
Transform
translate()
trim()
trim_array()
trim_scale()
TRUNCATE
ts_delete()
tsearch2
tsm_system_rows
tsm_system_time
tsvector_to_array()

U

unaccent
unistr()
unix_socket_directories
UNLISTEN
Unlogged table
unnest()
unsafe_tests
update_process_title
upper()
uuid-ossp

V

VACUUM
vacuum_cleanup_index_scale_factor
vacuum_cost_delay
vacuum_cost_limit
vacuum_cost_page_dirty
vacuum_cost_page_hit
vacuum_cost_page_miss
vacuumdb
vacuumlo
VALUES
version()

W

wal2json
wal2mongo
wal_block_size
wal_decode_buffer_size
wal_init_zero
wal_keep_segments
wal_keep_size
wal_level
wal_log_hints
wal_receiver_create_temp_slot
wal_recycle
wal_retrieve_retry_interval
wal_segment_size
walsender states
wal_skip_threshold
websearch_to_tsquery()
worker_spi
work_mem
Write-Ahead Logging (WAL)

X

XLOG_PAGE_MAGIC
XLogRecPtr
xml2
xmlcomment()
xmlconcat()
xmloption

Z

zheap

Tweets by postgrespedia

Version charts

Useful overviews

Useful links

pgPedia