This module implements a data type cube for representing multidimensional cubes. F
A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate
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
Internally, a GIN index contains a B-tree index constructed over keys, where each key is an element of one or more indexed items (a member
The PostgreSQL source distribution includes GIN operator classes for tsvector
An alternative backup strategy is to directly copy the files that PostgreSQL uses to store the data in the database;
As we saw in the previous section, the query planner needs to estimate the number of rows retrieved by a query in order to make good choices of query plans. This section provides
This section discusses how to upgrade your database data from one PostgreSQL release to a newer one.
Durability is a database feature that guarantees the recording of committed transactions even if the server crashes or loses power. However, durability adds significant database
NameDROP MATERIALIZED VIEW -- remove a materialized view Synopsis
Page 55 of 60