OmniPITR project that I wrote about some time ago is going on. Just today I finished tests for omnipitr-backup-slave - part of OmniPITR which lets you make hot-backups of WAL-slave machine - without any additional load on master. As previously - please ...

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.

Thanks to the company I work for OmniTI I was working on pretty cool project. Name of the project is OmniPITR, and here is what it is, why, how, and where to get it.

Just thought I'll share it - maybe somebody else will use it. I'm using KDE 3.5, so the final "dcop ..." command, simply sets the file as current wallpaper. I also use 1680x1050 resolution - which you can probably guess from the ...

I just updated explain.depesz.com with bugfix, which changes the way Bitmap Index Scan and Bitmap Heap Scan are displayed. Apparently index and table names were not shown previously. Thanks go to Viktor Rosenfeld for spotting and reporting the bug.

I just updated explain.depesz.com with 2 new interface features: When you put mouse cursor over node, it will mark direct child nodes with When you click on node, all child nodes (even indirect) ...

I just modified the internals of explain.depesz.com. Now, it finally stores the plans in database (previously it stored the plans as files in dedicated directory). Effect for enduser is just that history page should load faster. But, having the data in database ...

I just updated explain.depesz.com with the newest explain-parsing library version (Pg::Explain v 0.09). This version will hit CPAN mirrors in next couple of hours. Changes: Fix exclusive time calculations Make PE::Node understand Bitmap scans (heap and index) Add proper handling of nodes that were "never ...

Changes: Apply patch from Filip Rembiałkowski, which adds first header and last header display - for example to see time range the analysis was on. SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk

Some years ago I learned of existence of (supposedly cool) POE framework for Perl. I tried to use it for some projects, but the learning curve proved to be fatal for my interest. All the time I felt that POE is ...