PostgreSQL News

Change in behavior with fsync()

Starting with PostgreSQL 1.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 the fsync() behavior has changed. Here is what the PostgreSQL group ...
Read More
Microsoft Acquires Citus Data

Microsoft acquires Citus

Microsoft recently acquired Citus Data. Citus is an innovative open-source extension to PostgreSQL that transforms PostgreSQL into a distributed database, ...
Read More

Defend your data quality with constraints

In computer science, garbage in, garbage out is where bad, or nonsense input data produces nonsense output or "garbage". How ...
Read More

Tracking and Managing PostgreSQL Connections

PostgreSQL connections are process based not threaded like some other databases.  Like everything else there are pros and cons to ...
Read More

How to reload config settings without restarting database

If you are making modifications to the PostgreSQL configuration file (postgresql.conf) you will need to reload the file for your changes ...
Read More