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 Bruce Momjian
If you often use the timestamp data type, you might not be making full use of it. In these queries: CREATE TABLE tztest (x TIMESTAMP); INSERT INTO tztest VALUES (CURRENT_TIMESTAMP); SELECT * FROM tztest;              x ---------------------------- 2016-10-25 18:49:20.220891 SHOW timezone;   TimeZone ------------ US/Eastern SET timezone = 'Asia/...
MORE
By Robert Haas
Since I just committed the last pending patch to improve hash indexes to PostgreSQL 11, and since most of the improvements to hash indexes were committed to PostgreSQL 10 which is expected to be released next week, it seems like a good time for a brief review of all the work that has been done over the last 18 months or so.  Prior to version 10,...
MORE
By Bruce Momjian
PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java language and hamper its adoption. First, there are a limited number of people who know both Java and the Postgres backend code. Fortunately Chapman Flack has recently resumed PL/Java development. Second...
MORE
By Debra Brucato
Training
IT professionals have many new responsibilities around data management and strategy. The pace of change is very rapid in modern organizations. Database administrators and developers are joining forces. DevOps teams are now working together to rapidly develop new applications and replatform legacy applications. And, open source technology has never...
MORE
By Bruce Momjian
The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The question has always been what amount of logic should be encoded in the database vs. in client applications or application servers. Beyond using the database as a simple data store, there are three levels...
MORE
By Debra Brucato
IT hiring managers want certifications, and are willing to pay employees more for them. Those were key findings in the annual Open Source Jobs Report released recently by The Linux Foundation. Based on a survey conducted with tech career hub Dice, the report found that a growing number of hiring managers are more likely to hire a job candidate...
MORE
By Bruce Momjian
Oh, how I love the title of this 2014 Slashdot request, "Which NoSQL Database For New Project?" The user already knows the type of clients (iPhones and Android phones) and the middleware (Php/Symfony or Ruby/Rails) and then comes the zinger, "I would like to start with a NoSQL solution for scaling …." In addition to the question of whether Ruby...
MORE
By Bruce Momjian
In a March blog post I talked about the mismatch between what people expect from Postgres in terms of hints, and what exists. In this blog post I would like to cover the more general case of when people should expect feature parity with their previous database, and when such expectations are unreasonable. First, imagine if every database had the...
MORE
By Marc Linster
Data now comes in a wide variety of formats, giving rise to more heterogeneous data collections, often resulting from a commonly employed strategy of choosing the data management solution best suited for the data type and application demands. Selecting the right “horse for the course” approach results in a phenomenon known as polyglot persistence...
MORE
By Taylor Graham
In my role, I frequently talk to organizations about their top priorities for their software applications. Time and again, speed to market wins the day. They consistently say that getting to market quickly with new products and features that enable real-time engagement with their customers is their number one goal. And, it’s for this reason that...
MORE