Yearly Archives: 2014

/2014

Synchronous Commit

While I was at PGConf.EU a couple of weeks ago in Madrid, I attended a talk by Grant McAlister discussing Amazon RDS for PostgreSQL.  While it was interesting to see how Amazon had made it very simple for developers to get a production PostgreSQL instance quickly, the thing that really caught my eye was the [...]

By | November 10th, 2014|Categories: Jim PostgreSQL, OpenSCG, PostgreSQL|Tags: , |Comments Off on Synchronous Commit

PostgreSQL Dollar Quoting

I recently attended a excellent meetup about Redshift and one of the comments by the presenter was the trouble of the running of the UNLOAD command. The trouble they were having was that the UNLOAD command takes an SQL statement as a parameter, but if that SQL statement has strings, you need to escape everything [...]

By | October 7th, 2014|Categories: Jim PostgreSQL|Tags: , |Comments Off on PostgreSQL Dollar Quoting

FTP I/O from PostgreSQL

PostgreSQL applications at times need to communicate with external servers using FTP. Oracle has the UTL_TCP package that is very useful for PL/SQL applications. PostgreSQL doesn’t have an equivalent package, but it does have something really powerful … the ability to write functions in various scripting languages. PostgreSQL has four languages that are part of [...]

By | August 21st, 2014|Categories: PostgreSQL, tip|Comments Off on FTP I/O from PostgreSQL

Hierarchical Queries using PostgreSQL

One of the major hurdles faced when converting Oracle’s PL/SQL code to any other database is to find the equivalent of START WITH and CONNECT BY PRIOR. This SQL in Oracle provides a very powerful way of writing hierarchical queries, something that comes in really handy when dealing with hierarchical data – this is fairly [...]

By | August 15th, 2014|Categories: PostgreSQL, tip|Comments Off on Hierarchical Queries using PostgreSQL

Trigger Overhead (Part 2)

I found a bit more time dig into timing of triggers and their overhead so I wanted to see how much overhead the choice of procedural language affected performance. I followed the same testing methodology from my original trigger test. For this test I created an empty trigger in the following languages: PL/pgSQL CREATE FUNCTION [...]

By | May 21st, 2014|Categories: Jim PostgreSQL|Tags: , |Comments Off on Trigger Overhead (Part 2)

Trigger Overhead

I recently had discussions with some folks about triggers in PostgreSQL. They had two main questions. What is the overhead of putting a trigger on a table? Should a trigger function be generic with IF statements to do different things for INSERT, UPDATE and DELETE? So I created a simple test to verify some assumptions. [...]

By | May 7th, 2014|Categories: Jim PostgreSQL|Tags: , |Comments Off on Trigger Overhead

PostgreSQL Videos

With all of the new users to PostgreSQL, one of the things we wanted to do for PGConf NYC this year was to have a video showing the history of PostgreSQL. We ended up with a very professional video showing how the features have grown over the years and by the applause of the attendees [...]

By | April 16th, 2014|Categories: Jim PostgreSQL|Tags: , , |Comments Off on PostgreSQL Videos

PostgreSQL Studio is now on Heroku

One of my main objectives when writing PostgreSQL Studio was to help new users learn PostgreSQL. One of the main drivers of new PostgreSQL users is the different cloud players with Heroku being one of the biggest so it only made sense to start there. I've gone through the process of making PostgreSQL Studio an [...]

By | March 19th, 2014|Categories: Jim PostgreSQL|Tags: , |Comments Off on PostgreSQL Studio is now on Heroku

Stinger Delivers Fast Hive SQL via YARN & TEZ

The latest BigSQL bundle now includes Stinger and Tez to dramatically improve performance and extend the SQL dialect. In the latest distribution of BigSQL Release 2, it is extremely easy to get started exploring Tez and Stinger in your own sandbox environment. Taking advantage of YARN, Stinger is now delivering on its three main goals [...]

By | March 12th, 2014|Categories: Big Data, BigSQL, OpenSCG|Comments Off on Stinger Delivers Fast Hive SQL via YARN & TEZ