Showing posts with label postgresql. Show all posts
Showing posts with label postgresql. Show all posts
Sunday, May 26, 2019

Table Inheritance: What's it Good For?

›
Table inheritance is one of the most misunderstood -- and powerful -- features of PostgreSQL.  With it, certain kinds of hard problems becom...
33 comments:
Friday, September 21, 2018

Thoughts on the Code of Conduct Controversy

›
My overall perspective here is that the PostgreSQL community needs a code of conduct, and one which allows the committee to act in some case...
4 comments:
Monday, February 13, 2017

PostgreSQL at 10TB and Beyond Recorded Talk

›
The PostgreSQL at 10 TB And Beyond talk has now been released on Youtube. Feel free to watch.  For the folks seeing this on Planet Perl Iro...
Thursday, January 26, 2017

PL/Perl and Large PostgreSQL Databases

›
One of the topics discussed in the large database talk is the way we used PL/Perl to solve some data variety problems in terms of extractin...
Sunday, August 14, 2016

Forthcoming new scalable job queue extension

›
So for those of you who know, I now spend most of my time doing more general PostgreSQL consulting and a fair bit of time still on LedgerSM...
Tuesday, August 2, 2016

PostgreSQL, PL/Perl, and CVE-2016-1238

›
This post is about the dangers in writing user defined functions in untrusted languages, but it is also specifically about how to avoid CVE-...
Sunday, February 21, 2016

A couple annoyances (and solutions) regarding partitioned tables

›
In one of my projects we had an issue where a large table that was under huge transactional load was having trouble with autovacuum not keep...
Wednesday, February 10, 2016

Why Commons Should Not Have Ideological Litmus Tests

›
This will likely be my last post on this topic.  I would like to revive this blog on technical rather than ideological issues but there seem...
Tuesday, January 26, 2016

On Contributor Codes of Conduct and Social Justice

›
The PostgreSQL, Ruby, and PHP communities have all been considering codes of conduct for contributors. The LedgerSMB community already uses...