Manage Database Objects
These topics cover creating and maintaining database objects such as tables, views, and indexes, along with reading and writing data through them and controlling transactions.
Tables and storage models
Specify a distribution policy when creating a table, because row data is spread across segments.
Choose among the heap, append-optimized, UnionStore, and PAX storage formats.
Divide a large table into smaller ones so that a query scans only the data it needs.
Read and write data
The basic form of the SELECT statement.
Insert, update, and delete operations on table rows.
Views and indexes
Save frequently used or complex queries. A view occupies no disk and runs as a subquery when accessed.
Persist query results as a table, for results that are reused often.
Indexes behave differently in a distributed system than in a traditional database. Check the conditions before adding one.
Block range indexes, for very large tables whose column values correlate with physical storage order.
Transactions
Bundle multiple SQL statements into an all-or-nothing operation.
How isolation levels and concurrent transactions affect each other.
Cross-cluster and object management
Query across multiple PostgreSQL database clusters, pushing work down to reduce data transfer.
Attach custom labels to databases, users, tables, and other objects for classification and monitoring.