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: , , , , | 12 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

Robert Treat reported an error with find.best.tablespace.split.pl. In some cases it could die with 'division by zero' error. Problem was solved using patch from Robert, which simply treats "0" in number of rows fetched or written, as '0.001'. Additionally, I added a ...

After nearly 3 weeks of functioning, I just uploaded update to explain.depesz.com. New things are not really spectacular - I added help with proper explanation on what each color means and contact form in case somebody had ideas on what to ...