PostgreSQL Blogs

/PostgreSQL Blogs

Connecting SQLServer with Postgres using tds_fdw in easy steps

I have been posting about different types of FDWs available with Postgres distribution by BigSQL. Recently one of our customer had a reqirement of bridging their SQLServer database with Postgres. Postgres by BigSQL is already equiped with it. Here is how we can set it up in simple, easy steps. Step 1. Install FreeTDS in [...]

C++14 and Postgres

The C++ 14 specification came with huge improvements: Auto type deduction, lambdas, movable RValue expressions etc. -- the list is huge. Its a dream come true for lazy programmers like me : write less code & create fewer bugs ;) And get huge performance gains for free. OK this time I thought I'd try some [...]

By | March 28th, 2017|Categories: BigSQL, Jobin PostgreSQL, PostgreSQL Blogs|0 Comments

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

In a previous blog post we talked about the technical details behind the new CassandraFDW that enables PostgreSQL to connect to a Cassandra cluster. This provides PostgreSQL users the ability to easily read and write data to a very popular open source multi-master database that can support writes in multiple data centers. This means if [...]

Which standby was that again?

In any modern PostgreSQL installation, there's usually at least one streaming replication standby server feeding off your production master. In fact, there's usually several. Being the good PostgreSQL administrator that you are, you've already enabled logging of replication commands in postgresql.conf thusly: log_replication_commands = on But what you're probably not doing is having each standby [...]

PL/pgSQL Profiler 3 (plprofiler) is released

Finding performance problems in deeply nested PL/pgSQL business logic is difficult.One of the reasons is that PL/pgSQL hides anything happening in the PL code. None of the SQL queries inside of all the nested function and trigger calls ever shows up in...

By | November 3rd, 2016|Categories: OpenSCG, PostgreSQL, PostgreSQL Blogs|Tags: , , |Comments Off on PL/pgSQL Profiler 3 (plprofiler) is released

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

pgBackRest with PostgreSQL Sandbox on Debian / Ubuntu

pgBackRest is one of the most powerful backup solutions available for PostgreSQL. It has enterprise level features like compression, multiple channels (threads) of backup execution, incremental and differential backups etc. The official documentation is Debian-centric in its focus. I wanted to test it out with the PostgreSQL sandbox from the BigSQL project. Setting up PostgreSQL Sandbox and Installing pgBackRest The BigSQL [...]

By | July 26th, 2016|Categories: Jobin PostgreSQL, PostgreSQL Blogs|0 Comments