Data replication has become a more strategic operation as datacenters expand
in complexity and geographically. Data is increasingly off-loaded from
transactional systems into specialized applications and databases for greater
analysis or digital innovation. But by its very design, replication ...
Database reliability is an ongoing process, not a one-time activity. And your
database disaster recovery (DR) plans are a key part of keeping your business
systems reliable. However, in today’s culture that embraces the famous Ron
Popeil mantra of “set it, and forget it,” maintaining hig ...
IBM recently announced RapidBuild, a reseller channel program that enables
organizations to adopt trending technologies like cloud, big data and
mobility—quickly and efficiently—with the help of global technology
integrators. The first IBM partner to enroll in the RapidBuild program is ...
Noted psychologist Noel Burch developed a model called the “Four Stages for
Learning Any New Skill” to better understand the often slow and
uncomfortable process of learning something new. The model reveals that
everyone encounters the same 4 learning stages whether learning to play an
As you may know, many of us from the pgAdmin team have been hard at work on
pgAdmin 4 for some time now. pgAdmin 4 is a complete rewrite of pgAdmin (the
fourth, as you may guess), the previous version having reached the end of
it's maintainable life after 14 years of development. Work on the ...
EnterpriseDB® (EDB™) developed a high-performance tool for loading data in
bulk called EDB*Loader that is twice as fast as PostgreSQL COPY and
outperforms standard SQL statement for bulk loading of JSONB data. The tool
is part of EDB Postgres™ Advanced Server. The recent 9.5 release of ED ...
This is part 2 in a 4 part blog series on improvements coming in PostgreSQL
9.6 Part 1 - Horizontal Scalability Join Pushdown Sort Pushdown "Walk and
chew gum at the same time" Part 2 - Monitoring VACUUM progress monitoring
Wait monitoring Part 3 - Parallelism Part 4 - Vertical Scalabi ...
Middleware doesn’t get the respect it deserves. Considered the glue that
holds together the more complex and more business-critical components in the
software stack, middleware is often installed and forgotten. But middleware
can have significant impact on the operation and performance in th ...
In my previous blog post about horizontal scalability changes in PostrgreSQL
9.6, I covered pushing sorts and joins to the remote server, but Robert Haas
(EnterpriseDB) has just committed a change that allows DML (that's UPDATEs
and DELETEs) to be pushed to the remote server too. This is thank ...
Today’s connected enterprise requires a single database that can handle
both structured and unstructured data efficiently and that adapts dynamically
to swiftly changing and emerging data types. For many organizations, that
database is Postgres. With JSON, Postgres can support document datab ...
PostgreSQL 9.6 is shaping up to be an impressive release, so I thought I'd
try to summarise some of the big features and improvements that it will
bring. This certainly won't be exhaustive, but it will touch upon areas I've
looked at closely. I'm looking at breaking this down into the followin ...
There is a new index type in PostgreSQL version 9.5 called BRIN, for "Block
Range Index". BRIN is an exciting feature for the 9.5 release because it can
quickly organize very large tables for analysis and reporting, moving
PostgreSQL deeper into the big data space. BRIN is useful where indexed ...
To say the database market is evolving would be a gross understatement. New
data types and sophisticated new analytic requirements, combined with
increasing pressure to lower costs without sacrificing functionality is
ushering in an era of great change and great opportunity in the database
I just committed a very important patch to PostgreSQL. The short summary
for the patch is "Don't vacuum all-frozen pages." and it follows up on a
patch I committed last week, whose short summary was "Change the format of
the VM fork to add a second bit per page." This led Andres Freund
It is fitting that the most powerful piece of advice to keep in mind when
preparing to negotiate your new license agreement with Oracle is itself most
commonly associated with ancient Greece’s Socrates. It is the aphorism
“know thyself.” I would also add an additional element: “contro ...