UsefulLinks
Computer Science
Databases
PostgreSQL Database
1. Introduction to PostgreSQL
2. Installation and Basic Management
3. SQL Fundamentals in PostgreSQL
4. Data Types
5. Advanced Querying
6. Indexes and Performance
7. Transactions and Concurrency Control
8. Procedural Programming and Functions
9. Security and User Management
10. Database Administration
11. Backup, Recovery, and Replication
12. Advanced PostgreSQL Features
12.
Advanced PostgreSQL Features
12.1.
Partitioning
12.1.1.
Declarative Partitioning
12.1.2.
Range Partitioning
12.1.3.
List Partitioning
12.1.4.
Hash Partitioning
12.1.5.
Subpartitioning
12.1.6.
Managing Partitions
12.1.7.
Partition Pruning
12.2.
Foreign Data Wrappers
12.2.1.
Overview of FDW
12.2.2.
Installing FDW
12.2.3.
Configuring FDW
12.2.4.
Connecting to Other Databases
12.2.4.1.
postgres_fdw
12.2.4.2.
mysql_fdw
12.2.4.3.
oracle_fdw
12.2.5.
Querying Foreign Tables
12.2.6.
Data Modification via FDW
12.3.
Extensibility
12.3.1.
Creating Custom Extensions
12.3.2.
Installing Extensions
12.3.3.
Managing Extensions
12.3.4.
Popular Extensions
12.3.4.1.
PostGIS
12.3.4.2.
pg_stat_statements
12.3.4.3.
hstore
12.3.4.4.
citext
12.3.5.
Custom Data Types
12.3.6.
Custom Operators
12.3.7.
Custom Functions
12.3.8.
Event Triggers
12.3.9.
Procedural Languages
12.3.9.1.
PL/Python
12.3.9.2.
PL/Perl
Previous
11. Backup, Recovery, and Replication
Go to top
Back to Start
1. Introduction to PostgreSQL