The EDB Blog

Follow the EnterpriseDB Blog for the latest on all things EDB Postgres. From news to how-tos, our community of PostgreSQL experts is always sharing leading-edge insights.
By Jeannot Bos
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. My...
MORE
By Robert Haas
I previously suggested that we might be able to get parallel sequential scan committed to PostgreSQL 9.5.  That did not happen.  However, I'm pleased to report that I've just committed the first version of parallel sequential scan to PostgreSQL's master branch, with a view toward having it included in the upcoming PostgreSQL 9.6 release. Parallel...
MORE
By Phil Vacca
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...
MORE
By Dick Dowdell
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. ...
MORE
By Dick Dowdell
Common practice in relational database design is to utilize a non-repeating, ordered series of integers for primary keys (PK) and by extension, foreign keys (FK).  This practice has worked so well and efficiently for database designers that all commercially viable RDBMSs provide some means of automatically generating non-repeating, ordered...
MORE
By Jeannot Bos
Red Hat recently hosted its annual Red Hat Forum Benelux in the Netherlands and EnterpriseDB (EDB) was one of the participating local partners. Mike Huseman, Senior Vice President of Global Sales & Business Development at EDB, delivered one of the keynote addresses. Huseman was able to highlight the long partnership EDB has enjoyed with Red...
MORE
By Ed Boyajian
Database migrations from closed source to open source have become a particularly hot topic recently as I have been asked by customers, analysts, investors (and a few competitors!) what’s driving the accelerated changes in enterprise and government IT departments.  We have been both pursuing and pushing this change to Postgres for over 10 years now...
MORE
By Adam Wright
Released nearly 15 years ago, PostGIS is an open source extension to Postgres that spatially enables your database server, and follows the OGC Simple Features for SQL specification. If you are coming from another standards based spatial database you may notice similarities in the spatial data types, naming conventions, and functionality. You can...
MORE
By Vibhor Kumar
EnterpriseDB (EDB) customers who moved/migrated their database from Oracle to EDB’s Postgres Plus Advanced Server (PPAS) frequently ask for Global Temporary Table in PPAS. Currently, PPAS doesn’t support Global Temporary tables. However, there is a way users can achieve this functionality in PPAS. Before we continue with the implementation, let's...
MORE
By Pierre Fricke
I’ve been working in the IT industry long enough now to see how techies appropriate – and quite often misappropriate – words in the English language.  One such word is “legacy.”  For anyone outside the IT industry this could mean a couple of different things, but it probably has a more positive connotation than it does for your average CIO or IT...
MORE