Registering Event Log on Windows
  • References/Database/PostgreSQL/Server Setup and Operation

To register a Windows event log library with the operating system, issue this command:

2025-01-10 15:47:30
REFRESH MATERIALIZED VIEW
  • References/Database/PostgreSQL/Commands

NameREFRESH MATERIALIZED VIEW -- replace the contents of a materialized view Synopsis

2025-01-10 15:47:30
cube
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

This module implements a data type cube for representing multidimensional cubes. F

2025-01-10 15:47:30
Performance Tips: Non-Durable Settings
  • References/Database/PostgreSQL/Performance Tips

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

2025-01-10 15:47:30
Range Functions and Operators
  • References/Database/PostgreSQL/Functions/Range

See Section 8.17 for an overview of range types. Table 9-49 shows

2025-01-10 15:47:30
Internals//SP-GiST Indexes
  • References/Database/PostgreSQL/Internals/SP-GiST Indexes

SP-GiST is an abbreviation for space-partitioned GiST. SP-GiST supports

2025-01-10 15:47:30
RELEASE SAVEPOINT
  • References/Database/PostgreSQL/Commands

NameRELEASE SAVEPOINT -- destroy a previously defined savepoint Synopsis

2025-01-10 15:47:30
Catalogs: pg_ts_parser
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning

2025-01-10 15:47:30
Catalogs: pg_file_settings
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each

2025-01-10 15:47:30
Routine Vacuuming
  • References/Database/PostgreSQL/Maintenance

PostgreSQL databases require periodic maintenance known as vacuuming. For many installations, it is sufficient to

2025-01-10 15:47:30