Monthly Archives: September 2016


PostgreSQL Replication Checklist

Replication is a key part of creating an "Enterprise" Postgres deployment, to support high availability, failover, disaster recovery, or scale-out queries. Built-in streaming replication was added to PostgreSQL in version 9.0, but the Postgres community has had a number of trigger based replication options for many years, with the big 3 being Slony-I, Londsite, and Bucardo (we're [...]

By | September 28th, 2016|Categories: Dave PostgreSQL|Tags: , , , , |0 Comments

Integrating Cassandra, Spark, PostgreSQL and Hadoop as a Hybrid Data Platform – Part 2

In the previous post, we provided a business and architectural background for the Postgres FDWs that we are developing for Spark, Hadoop and Cassandra. In particular, we highlighted the key benefits of bringing Cassandra and PostgreSQL together. With this post, we will start taking a more technical look at the Cassandra FDW. The C* FDW [...]

By | September 23rd, 2016|Categories: Affan PostgreSQL, OpenSCG, PostgreSQL Blogs|Tags: , , , |0 Comments

Improve PostgreSQL on Windows performance by 100%

It sounds like click-bait, or one of those late night TV promotions - "Improve your database performance by 100% - by changing just this one setting!" But in this case, it's true - you can drastically improve PostgreSQL on Windows performance by changing one configuration setting - and we made this the default in our [...]

By | September 20th, 2016|Categories: Dave PostgreSQL, OpenSCG|Tags: , , |0 Comments

Integrating Cassandra, Spark, PostgreSQL and Hadoop as a Hybrid Data Platform

Today many organizations struggle to keep up with their database requirements, for example, to: store and analyze high-velocity and rapidly-growing data such as logs, package tracking events, sensor readings and machine-generated streams. ensure 24/7 availability of customer-facing websites, services and apps even when a subset of their data centers, servers or data are offline. support [...]

Read environment variables from PostgreSQL using plpython

Sometimes in your PostgreSQL code you want to read an environment variable - whether to get the input file location for a data load, or check that the postgres user has the right path set, or verify that the TDSDUMP environment variable is set when configuring the tds_fdw to connect to SQL Server. Here's a plpython based [...]

By | September 9th, 2016|Categories: Dave PostgreSQL|Tags: , , |0 Comments