Just released version 0.3.0 of our tool for handling WAL based replication in PostgreSQL - OmniPITR. Version jump is related to addition of another tool - omnipitr-synch. This tool is used to copy PostgreSQL data dir (including all tablespaces of course) ...

Today, I released 2 new versions (new features in 0.5, and then quick bugfix in 0.51) of Pg::Explain Perl library. This is the base of explain.depesz.com - the code that does heavy lifting of parsing plans, and providing them in uniform ...

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 ...

June 2nd, 2010 by depesz | Tags: , , , , | 14 comments »

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.

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

Changes: Fix bug spotted by Selena Deckelmann %l is *number* not some string. SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk