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 Dave Page
The world in which PostgreSQL operates today is very different from its origins in 1986. Where once PostgreSQL might have been considered an academic exercise even following its initial Open Source release, today it operates in a much more dynamic environment.
Open source and traditional commercial software now work alongside one another in many...
MORE
MORE
By Bruce Momjian
You might know that Postgres supports materialized views and foreign data wrappers (fdw). Briefly, materialized views allow for queries to be materialized and refreshed on demand. Foreign data wrappers allow data to be pulled from foreign data sources, like Nosql stores and other Postgres servers.
What you might not have considered is that...
MORE
MORE
By Marc Linster
Virtual machines are by far the most prevalent deployment model for data centers – close to 99%. What was once a revolutionary idea has transformed into the best practice standard for data center deployments. Virtualization has evolved into a very well established and understood technology that is also extremely robust and reliable. And, the...
MORE
MORE
By Bruce Momjian
On the server side, high availability means having the ability to quickly failover to standby hardware, hopefully with no data loss. Failover behavior on the client side is more nuanced.
For example, when failover happens, what happens to connected clients? If no connection pooler is being used, clients connected to the failed machine will need...
MORE
MORE
By RUPINDER CHANIANA
Licensing complexity, rising costs, and audit risk are motivating Oracle customers to jump start their migration efforts to alternative database platforms. Even the largest of enterprises and the most restrictive of government agencies are actively evaluating open source database alternatives. Reduced expense and greater agility are significant...
MORE
MORE
By Bruce Momjian
Now that everyone is using IPv6 () it might be time to start playing with it. Postgres has had full IPv6 support for years, so Postgres is a good place to start, particularly with IPv6-aware data types.
Since IPv6 addresses are 128-bits instead of IPv4's 32-bits, they can be quite long, e.g. 2001:0db8:85a3:0000:0000:8a2e:0000:7334. As you can see...
MORE
MORE
By Bruce Momjian
You might be aware of the interval data type, which allows mathematical operations on date, time, and timestamp values. This can lead to odd behavior, but this email posting showed me a new oddity when dealing with months containing a different number of days.
First, let's summarize how many days are in the first five months of 2017:
2017-01 ...
MORE
MORE
By Marc Linster
Digital transformation has officially become the key to meeting modern customer expectations. Only two years ago, Don Butler, Executive Director of Connected Vehicle and Services at Ford, famously said, "We need to adopt more and more of a mindset of a software or services company.” And today, there is not a car manufacturer that is not actively...
MORE
MORE
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
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
MORE