Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, released an updated version ...

The CERN PGDay builds on the experience of past PostgreSQL events at CERN and a newly establish collaboration with SwissPUG.

This release contains a few fixes from 17.1. For information about new features in major release 17, see Section E.3.

Commercial support is available from many different companies providing professional services to the PostgreSQL community.

pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/restore ...

DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index. Drop the index without locking out concurrent selects, inserts, updates, and ...

Continuous archiving can be used to create a high availability (HA) cluster configuration with one or more standby servers ready to take over operations if the primary server fails. This capability is ...

41.1.1. Advantages of Using PL/pgSQL ...

If you have pattern matching needs that go beyond this, consider writing a user-defined function in Perl or Tcl. While most regular-expression searches can be executed very quickly, regular ...

Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER, and pg_amcheck made incomplete efforts to operate safely when a privileged user is maintaining another user's objects. Those ...

libpq pipeline mode allows applications to send a query without having to read the result of the previously sent query. Taking advantage of the pipeline mode, a client will wait less for the server, ...

38.1. Overview of Event Trigger Behavior Home 38.3. Writing Event Trigger Functions in C ...