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 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
By Pierre Fricke
James Cash Penney, the founder of JCPenney, once said, “Growth is never by mere chance; it is the result of forces working together.” The retail pioneer could be speaking of the forces underway in the database industry that have enabled EnterpriseDB to emerge as a formidable force in the market. The performance enhancements and new features from...
MORE
By Pierre Fricke
Most IT organizations have made large investments in infrastructure and applications that have been running the business for years. Keeping this infrastructure costs a lot of money, perhaps up to 80% of an IT budget. To make things worse, some vendors, notably leading database vendors, employ sophisticated strategies to lock you into contracts...
MORE