March 12th, 2011 by depesz | Tags: array, arrays, hash, perl, pg91, plperl, postgresql, records, rows | 2 comments »
On 18th of February, Alvaro Herrera committed patch: Convert Postgres arrays to Perl arrays on PL/perl input arguments More generally, arrays are turned in Perl array references, and row and composite types are turned into Perl hash references. This is done recursively, in ...
June 28th, 2010 by depesz | Tags: benchmark, btree, hash, index, performance, perl, postgresql, test | 7 comments »
Today, Mattias|farm on IRC asked how to create primary key using HASH index. After some talk, he said that in some books it said that for "=" (equality) hash indexes are better. So, I digged a bit deeper.
