Monthly Archives: May 2014

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