Built-in sharding is something that many people have wanted to see in PostgreSQL for a long time. It would be a gross exaggeration to say that PostgreSQL 11 (due to...
In this video, we will have a look at how parallel sequential scan can be used in EDB Postgres Advanced Server to enhance the performance of the queries.
Contributed by Richard Yen I recently got a few support cases from customers seeking to connect Postgres with LDAP (usually with some form of SSL/TLS encryption, to ensure security). I...
You might be aware that the sql standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard, with slight modifications. For example, you cannot...
Postgres has supported multi-column indexes since 1997, e.g. create index i_test on test (a, b, c). It can easily use an index if the supplied columns are all at the...
Application_name might be one of those Postgres settings that you have seen in various places but never understood its purpose. It is true that setting application_name doesn't change the behavior...
I recently went to PGConf.EU, the European PostgreSQL conference that was held in Tallinn, Estonia on November 1-4. This annual event for Postgres developers and users is a great opportunity...
The three-year return on investment of the EDB Postgres™ Platform is 168%, according to a new white paper on the comprehensive business impact of EDB Postgres based on interviews with...
Postgres introduced JSON and JSONB in versions 9.3 and 9.4, respectively, with JSONB (Binary Javascript Object Notation) being the canonical form of JSON, stored as binary objects with improved compression...
