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 said: “Two vast and trunkless legs of stone Stand in the desert. Near them, on the sand, Half sunk, a shattered visage lies, whose frown, […]
Redislog: Integrating PostgreSQL with Logstash for devops real-time monitoring
/4 Comments/in Featured, Gabriele's PlanetPostgreSQL /by Gabriele BartoliniDuring the last October’s Italian PGDay and European PostgreSQL conference, my friend Marco Nenciarini and I had the pleasure to talk about a new open source plugin for PostgreSQL, called redislog. In that presentation (“Integrating PostgreSQL with Logstash for real-time monitoring”) we provided an example of our exploration/experimentation approach, with extensive and thorough coverage of […]
The process that created pglogical
/4 Comments/in pglogical, Umair's PlanetPostgreSQL /by Umair Shahidpglogical (logical replication for PostgreSQL) is the latest in the series of awesome products developed & supported by 2ndQuadrant. One of the key ingredients to making any product great is the process followed in developing it. We have tried to notch up our game with pglogical, let me describe some of the measures we have […]
2UDA – New features in Orange (Part 2)
/0 Comments/in Data Mining /by Lan ZagarOrange 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 this blog series. Two other new features that appeared recently (available in the latest 2UDA package) are the Color widget and the reporting functionality. The […]
On pglogical performance
/1 Comment/in pglogical, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraA 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 to discuss about all the things enabled by logical replication – the pglogical release announcement presents a quite good overview, and Simon also briefly explained […]
The Physics of Multi-Master
/5 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsIf 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. How that problem manifests itself is really based upon your choice of technology. Choosing Postgres, Oracle or ProblemoDB won’t change the problem, just gives you […]
Performance of Sequences and Serials in Postgres-XL
/7 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan DeolaseeIn 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 for a query doing thousands of INSERTs in a table with a serial column, incrementing sequence one at a time and making a network roundtrip […]
Why Logical Replication?
/0 Comments/in pglogical, Simon's PlanetPostgreSQL /by Simon RiggsPostgreSQL 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 properly known as Physical Streaming Replication since we are streaming a series of physical changes from one node to another. That means that when we […]
2UDA RC1 – New features in Orange (Part 1)
/2 Comments/in Data Mining /by Lan ZagarThe 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 features, improvements, and bug fixes. Summary of the more noticeable changes can be found in 2UDA release notes. In this first of a series of […]
Joins Don’t Scale!
/0 Comments/in Simon's PlanetPostgreSQL /by Simon Riggs“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 to realise is that the implicit topic we are talking about is massively parallel (MPP) databases, so what they are talking about is the scalability […]
The End of MongoDB
/1 Comment/in Simon's PlanetPostgreSQL /by Simon RiggsOn 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 said: “Two vast and trunkless legs of stone Stand in the desert. Near them, on the sand, Half sunk, a shattered visage lies, whose frown, […]