Orange is continuously being improved and made more friendly and useful for the users based on their feedback and experiences. Some new features were already described in Part 1 of...
A few days ago we released pglogical, a fully open-source logical replication solution for PostgreSQL, that’ll hopefully get included into the PostgreSQL tree in a not-too-distant future. I’m not going...
If you try to update the same data at the same time in multiple locations, your application has a significant problem, period. That’s what I call the physics of multi-master...
In Postgres-XL, sequences are maintained at the Global Transaction Manager (GTM) to ensure that they are assigned non-conflicting values when they are incremented from multiple nodes. This adds significant overhead...
PostgreSQL has built-in streaming replication. Why do we need new replication? Well, in some cases, we do need more. Which is why we have pglogical. The existing replication is more...
The 2UDA installation package was updated recently to include the newly released PostgreSQL 9.5 RC1. Also found in the new package is an updated version of Orange bringing some new...
“Joins Don’t Scale”. Well, that’s what I heard MongoDB said anyway. My response was “Huh? Yeh, they do”. So what gives? Who is right? Why the mixup? Well, first thing...
On hearing news that MongoDB had lost half its value recently, the phrase “Half sunk” came to mind from Shelley’s Ozymandias. I met a traveller from an antique land Who...
PostgreSQL 9.5 adds declarative row security. You can declare policies on tables and have them enforced automatically – for example, allowing user joe to only see rows with the owner...
Ok, so you have a PostgreSQL distribution on your Ubuntu server. You have created the data directory and initialized the database. Now you want to run the server in a...
