Improve database resiliency with new JDBC Connectors and EDB Failover Manager

Improve database resiliency with new JDBC Connectors and EDB Failover Manager This blog was co-written by Jason Davis.
EnterpriseDB is about to release an update to the Connectors for Postgres and EDB Postgres. The update will include some new capabilities in the JDBC driver to support connection failover.
read more
Mind the GaaP There remains significant uncertainty about the future of the Government Digital Service (GDS) in following the departure of its primary champion, Mike Bracken, this past summer. There have been some that suggested the GDS is entirely unnecessary and others who say that it should exist in a smaller form in today’s budget-constrained times.
read more
Parallel Sequential Scan is Committed!
This post originally appeared on Robert Haas' personal blog.
read more
Top 10 Steps to a Smoother Postgres Deployment Headaches will come with just about any new project but taking a pause and considering the following steps before getting started with a new Postgres deployment should save you quite a few. Even seasoned DBAs can benefit from a refresh on some of these topics. So, in order to reduce risk, minimize potential post-deployment problems, and eliminate long-term maintenance challenges, let’s consider the following Top 10 steps to a smoother Postgres deployment.
read more
Using Java to Manipulate SQL Structures and Arrays The only data structure recognized in traditional SQL databases was the row, and repeating groups were extracted into child rows linked through foreign keys.  It worked well but could be somewhat artificial and cumbersome for programmers.  With more powerful processors and plentiful memory, today’s SQL DMBSs have shrugged off those limitations.  Modern SQL DBMSs implement the concepts of data structures and of arrays — making the Java programmer’s job much easier.
read more