pgFoundry Project: pg_reorg - Newshttp://pgfoundry.org/news/?group_id=1000411
pgFoundry Project News of pg_reorgen-usCopyright 2016 pgFoundrytoru@users.pgfoundry.org (Toru Shimogaki)Fri, 09 Dec 2016 13:33:21 GMThttp://blogs.law.harvard.edu/tech/rsspgFoundry RSS generatorpg_reorg 1.1.11 releasedhttp://pgfoundry.org/forum/forum.php?forum_id=1967
This is a maintenance release for pg_reorg.<br />
<br />
This version have some fix and updates;<br />
<br />
- Supports PostgreSQL 9.4<br />
- Change not to wait for transactions in different databases.<br />
- Support for DESC, NULLS FIRST/LAST, COLLATE to index keys.<br />
<br />
Download from http://pgfoundry.org/frs/?group_id=1000411<br />
oonishitk@users.pgfoundry.org (Takashi Ohnishi)Thu, 08 Jan 2015 05:26:49 GMThttp://pgfoundry.org/forum/forum.php?forum_id=1967http://pgfoundry.org/forum/forum.php?forum_id=1967pg_reorg 1.1.10 releasedhttp://pgfoundry.org/forum/forum.php?forum_id=1954
This is a maintenance release for pg_reorg.<br />
<br />
There found a bug which causes data lost or data corruption, but it is very rare possibility to happen.<br />
Users should better to update to this version.<br />
oonishitk@users.pgfoundry.org (Takashi Ohnishi)Fri, 09 May 2014 02:17:48 GMThttp://pgfoundry.org/forum/forum.php?forum_id=1954http://pgfoundry.org/forum/forum.php?forum_id=1954pg_reorg 1.1.9 releasedhttp://pgfoundry.org/forum/forum.php?forum_id=1943
This is a maintenance update version of pg_reorg.<br />
This version supports PostgreSQL 9.3. oonishitk@users.pgfoundry.org (Takashi Ohnishi)Mon, 16 Dec 2013 21:51:53 GMThttp://pgfoundry.org/forum/forum.php?forum_id=1943http://pgfoundry.org/forum/forum.php?forum_id=1943pg_reorg 1.1.0 and pg_batch 1.2.0 releasedhttp://pgfoundry.org/forum/forum.php?forum_id=1701
pg_reorg 1.1.0 has a feature improvement to reorganize heavily-accessed tables. Older versions could wait for another processes infinitely, but the new one only can cancel other transactions after wait-timeout passed.<br />
<br />
pg_batch is a new tool in this project. It is a SQL job executor program for PostgreSQL. It generates job list from an external SQL script file, and execute the jobs in serial or parallel. It can be used as &quot;a better vacuumdb&quot; with the attached script to run VACUUM.<br />
itagaki@users.pgfoundry.org (Takahiro Itagaki)Wed, 21 Apr 2010 15:04:09 GMThttp://pgfoundry.org/forum/forum.php?forum_id=1701http://pgfoundry.org/forum/forum.php?forum_id=1701pg_reorg 1.0.4 releasedhttp://pgfoundry.org/forum/forum.php?forum_id=1561
pg_reorg 1.0.4 supports PGXS and fixes some bugs.<br />
<br />
Changes:<br />
- Support of PGXS.<br />
- Fix ownership bug. New toast table, toast index, and toast type should not have be owned by executor of pg_reorg, but by the original owner.<br />
- Modify LOCK to LOCK-NOWAIT-and-loop at swapping tables not to block other transaction when exclusive-locking takes long time.itagaki@users.pgfoundry.org (Takahiro Itagaki)Sat, 23 May 2009 09:54:06 GMThttp://pgfoundry.org/forum/forum.php?forum_id=1561http://pgfoundry.org/forum/forum.php?forum_id=1561pg_reorg 1.0.3 releasedhttp://pgfoundry.org/forum/forum.php?forum_id=1499
pg_reorg 1.0.3 supports PostgreSQL 8.2 and fix some bugs.<br />
<br />
Changes:<br />
- Supports PostgreSQL 8.2.<br />
- Fix bugs in reorganizing tables with TOAST.<br />
- DROP TABLE is executed out of exclusive locks to minimize lock time.<br />
- Use maintenance_work_mem instead of work_mem to sort tables.<br />
itagaki@users.pgfoundry.org (Takahiro Itagaki)Tue, 17 Feb 2009 01:50:37 GMThttp://pgfoundry.org/forum/forum.php?forum_id=1499http://pgfoundry.org/forum/forum.php?forum_id=1499pg_reorg 1.0.2 releasedhttp://pgfoundry.org/forum/forum.php?forum_id=1467
pg_reorg can re-organize tables on a postgres database without any locks so that you can retrieve or update rows in tables being reorganized. The module is developed to be a better alternative of CLUSTER and VACUUM FULL.itagaki@users.pgfoundry.org (Takahiro Itagaki)Mon, 15 Dec 2008 01:31:56 GMThttp://pgfoundry.org/forum/forum.php?forum_id=1467http://pgfoundry.org/forum/forum.php?forum_id=1467