miałem urlop. to zdanie jest istotne, bo urlopy biorę rzadko. nie lubię. i jak się okazuje – są po etmu istotne powody.
w lipcu pojechałem z moją panią i dziećmi samochodem do bułgarii. razem z nami pojechali znajomi – ale już innym samochodem.
Month: September 2008
Waiting for 8.4 – database-level lc_collation and lc_ctype
On 23rd of September, Heikki Linnakangas committed patch that was written by Radek Strnad (actually committed patch is a stripped-down version of original).
What it does? It adds ability to have (finally!) different collation order and character categories for different databases.
Continue reading Waiting for 8.4 – database-level lc_collation and lc_ctype
CitiBank – frontem do klienta (polish only)
Tak się złożyło, że jestem klientem CitiBanku.
Mam u nich konto biznesowe, i z tej okazji muszę co jakiś czas korzystać z ich systemu webowego.
Już parę razy do nich pisałem, że system jest wolny, nie zawsze wyświetla wszystkie informacje, ma problemy z transakcjami w niestandardowych walutach, ale to co zobaczyłem dziś mnie po prostu powaliło.
Continue reading CitiBank – frontem do klienta (polish only)
Getting record by 2 criteria, ordered by third – how to do it quickly?
Let's assume we have a simple table:
CREATE TABLE objects ( id serial PRIMARY KEY, category INT4 NOT NULL DEFAULT 0, object_type INT4 NOT NULL DEFAULT 0, entered_on TIMESTAMPTZ NOT NULL DEFAULT now() );
(This is simplification, but it contains all necessary columns).
What should I do to be able to quickly get 50 newest objects in given category/object_type (or in many categories/many object_types, or in all categories/object_types), optionally with limiting entered_on “older than …".
Continue reading Getting record by 2 criteria, ordered by third – how to do it quickly?
Waiting for 8.4 – pgbench with timed execution
Takahiro Itagaki wrote, and Tom Lane committed nice patch, which I personally find really helpful:
Add a duration option to pgbench, so that test length can be specified in seconds instead of by number of transactions to run. Takahiro Itagaki
Continue reading Waiting for 8.4 – pgbench with timed execution
pgsql-tools/analyze.pgsql.logs.pl
Changes:
- normalize BEGIN/START … statements
- normalize END/COMMIT … statements
- normalize ROLLBACK/ABORT … statements
SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk
Waiting for 8.4 – ordered data loading in pg_dump
Great (and admittedly long overdue) patch by Tom Lane:
Make pg_dump --data-only try to order the table dumps so that foreign keys' referenced tables are dumped before the referencing tables. This avoids failures when the data is loaded with the FK constraints already active. If no such ordering is possible because of circular or self-referential constraints, print a NOTICE to warn the user about it.
What it exactly means?
Continue reading Waiting for 8.4 – ordered data loading in pg_dump
pgsql-tools/analyze.pgsql.logs.pl
Changes:
- fix regexps for header – now it will be possible to sensibly analyze logs with informations about log archiving.
SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk
Waiting for 8.4 – \ef in psql
Today, Tom Lane committed patch, written by Abhijit Menon-Sen, which adds interesting feature to psql. Namely – it simplifies changing definition of functions.