What exactly is the PostgreSQL query optimizer capable of? Are you experiencing its full potential, or just scratching the surface? We recently released Part 1 of our two-part webinar series...
Starting v9.2, PostgreSQL is providing native data type support for JSON objects. Subsequent releases introduced JSONB (binary formatted JSON objects) and many data manipulation functions for JSONs, making it a...
In EDB’s recent webinar, Explaining the PostgreSQL Query Optimizer Part 1, EDB Vice President and Postgres Evangelist Bruce Momjian broke down the importance of the PostgreSQL query optimizer: what makes...
Transparent data encryption (TDE) is an optional feature supported by version 15 of EDB Postgres Advanced Server and EDB Postgres Extended Server. It encrypts any user data stored in the...
pgAdmin supports Kerberos authentication for user logins as well as connecting to databases. Kerberos is a popular authentication method but many people find it difficult to set up especially with...
Developing a frontend for a database can be a challenging task, especially when there are multiple runtimes / frameworks available for the language of your choice. We have been dealing...
pgAgent is a job scheduling agent for Postgres databases, capable of running multi-step batch or shell scripts and SQL tasks on complex schedules, which may be managed using pgAdmin. pgAgent...
Are you running the latest major version of PostgreSQL, released September 2022? PostgreSQL 15 brings with it a series of significant improvements made to performance, security and usability—just like each...
Tuning of the max_wal_size configuration parameter in PostgreSQL can have a profound effect on performance, but it's often overlooked or not given the priority it deserves in favour of other...
