Monday, August 31, 2015

Lock-polling script for ALTER TABLE

›
One of PostgreSQL's advantages over many other SQL databases is letting users modify database objects with a minimum of locking and fuss...
Friday, August 28, 2015

Stupid Hacks: Dictionary replace function

›
I write a lot more PL/pgSQL than I'd like to.  Not that I don't like SQL, but as a language PL/pgSQL really shows its thrown-togethe...
5 comments:
Friday, August 14, 2015

Most of the talks chosen for pgConfSV

›
Since we're still working on the schedule, I wanted to give folks a preview of the talks we've picked for pgConfSV .  We still have ...
Wednesday, August 12, 2015

Two Great Tastes That Taste Great Together: cstore + Pipeline

›
cstore_fdw , the column-store extension for PostgreSQL by CitusData, is a really good way to add compressed storage for archival data, and a...
4 comments:
Tuesday, August 11, 2015

Please, security test our code!

›
Since Oracle was so nice as to remind everyone what software security is really like with closed-source software, I wanted to remind people...
7 comments:
Friday, August 7, 2015

Understanding Unintuitive TABLESAMPLE Results

›
In 9.5 Alpha 2 : create table mil ( id int, val text ); insert into mil select i, i::text || '-val'  from generate_series(1,100000...
4 comments:
Thursday, August 6, 2015

Time to test 9.5 Alpha 2

›
PostgreSQL 9.5 Alpha 2 is out .  We're still calling this one an Alpha instead of a Beta, because major replumbing is still underway.  H...