On Wed, May 31, 2006 at 09:33:04PM +0000, Christopher Browne wrote: > Based on the discussion of the last day or so, we really need to see > about getting version 1.2 released. > > As far as I can tell, all of the issues Rod pointed out are resolved in > CVS HEAD, so that 1.2 should seriously diminish the need for > "super-skilled staff" when setting up Very Large Instances. Some issues > do not disappear; there will still be long running transactions that > cause some inconvenience, which is, to a great degree, an unavoidable > problem. But we can certainly get rid of a bunch of the "misfeature" cases.
There's some ideas in http://archives.postgresql.org/pgsql-hackers/2006-02/msg01164.php that could potentially eliminate the issues associated with long-running transactions, should someone want to push for it. In a nutshell, the idea is to provide a means for a transaction to list a set of tables that it will never touch (again). Vacuum can then take that into account when figuring out what the minimum XID that has to be kept in a table is. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
