PostgreSQL has native support for using SSL connections to encrypt client/server communications for increased

The catalog pg_depend records the dependency relationships between database objects. This information allows DROP

Each unlogged table, and each index on an unlogged table, has an initialization fork. The initialization fork is an empty table or index of the appropriate type. When an unlogged

It is very difficult to enforce business rules regarding data integrity using Read Committed transactions because the view of the data is shifting with each statement, and

NameROLLBACK PREPARED -- cancel a transaction that was earlier prepared for two-phase commit

The INSERT statement is used to populate a table with rows:

Traditionally, implementing a new index access method meant a lot of difficult work. It was necessary to understand the inner workings of the database, such as the lock manager

Aggregate functions compute a single result from a set of input values. The built-in normal aggregate functions are listed in Table 9-51 and Table

The most important disk monitoring task of a database administrator is to make sure the disk doesn't become full. A filled data disk will not result in data corruption, but

The pg_stat_statements module provides a means for tracking execution statistics of all SQL statements executed by a server. The