PostgreSQL

/PostgreSQL

Setting up PL/R with Postgres on Windows

1. Introduction Setting up extra extensions / features on proprietary platform like Windows is a challenge because we don't have a default build environment. Setting up a complete build environment for installing a language extension is bigger challenge. Thanks to vibrant community, many of the heavy lifting is already done. I would like to Acknowledge [...]

By | October 16th, 2017|Categories: BigSQL, Jobin PostgreSQL, PostgreSQL|3 Comments

Migrations: What applications should I migrate?

When you have made the decision to investigate migrating your database applications from one database platform to another, the next big question you will need to answer is ‘Which application(s)?’ It seems like an easy enough question but there are many variables involved in whether or not the migration will be smooth. Technically, any application [...]

By | March 9th, 2017|Categories: Migration, OpenSCG, PostgreSQL|Tags: , , |0 Comments

Migrating from MongoDB (back) to PostgreSQL

We helped a customer move from MongoDB back to PostgreSQL. It's an interesting story about some of the challenges of scaling a database platform and ways that PostgreSQL provides very reliable, robust, scalable data services. The Customer The customer is a software company that provides mobile enterprise security and threat protection. Their product provides security [...]

By | March 8th, 2017|Categories: Case Studies, Migration|Tags: , , |3 Comments

Why Migrate?

“Why migrate to Postgres?” is a question that we used to hear a lot in the past. There used to be a number of different reasons to migrate including, take advantage of new technology, a change of staff skills, vendor consolidation caused friction and of course, cost. Nowadays, the main reason we hear for migrating [...]

By | March 8th, 2017|Categories: Migration, OpenSCG, OpenSource, PostgreSQL, Uncategorized|Tags: , , , |0 Comments

Successful database Migrations : Are they really possible?

We talk to a lot of clients who want to perform database migrations but just about all of them are skeptical that the project will be a success. There are a number of reasons for this, including: Fear Lack of time to take on project Belief that their usage isn’t easy convertible to a new [...]

By | March 2nd, 2017|Categories: OpenSCG, OpenSource, PostgreSQL, thoughts, Uncategorized|Tags: , , , , |0 Comments

5 Tips to Prepare to Migrate to PostgreSQL

Migrating to PostgreSQL has many benefits - lower license costs, great community support, robust SQL support, powerful stored procedure languages, NoSQL key/value, document and full-text database capabilities, and many more. If you're moving from another relational database the migration can be fairly simple. Moving from a NoSQL database may require more application code changes but [...]

By | March 1st, 2017|Categories: Migration|Tags: , , |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