Received: from mailo.vtcif.telstra.com.au (mailo.vtcif.telstra.com.au [202.12.144.17]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA39983; Thu, 3 Feb 2000 18:30:49 -0500 (EST) (envelope-from chrisb@nimrod.itg.telstra.com.au) Received: (from uucp@localhost) by mailo.vtcif.telstra.com.au (8.8.2/8.6.9) id KAA07868; Fri, 4 Feb 2000 10:30:17 +1100 (EST) Received: from maili.vtcif.telstra.com.au(202.12.142.17) via SMTP by mailo.vtcif.telstra.com.au, id smtpdIuHAk_; Fri Feb 4 10:30:00 2000 Received: (from uucp@localhost) by maili.vtcif.telstra.com.au (8.8.2/8.6.9) id KAA26919; Fri, 4 Feb 2000 10:29:59 +1100 (EST) Received: from localhost(127.0.0.1), claiming to be "mail.cdn.telstra.com.au" via SMTP by localhost, id smtpd0hkd0j; Fri Feb 4 10:29:05 2000 Received: from lunitari.nimrod.itg.telecom.com.au (lunitari.nimrod.itg.telecom.com.au [192.53.254.48]) by mail.cdn.telstra.com.au (8.8.2/8.6.9) with ESMTP id KAA19268; Fri, 4 Feb 2000 10:29:04 +1100 (EST) Received: from nimrod.itg.telecom.com.au (majere [192.53.254.45]) by lunitari.nimrod.itg.telecom.com.au (8.9.1/8.9.3) with ESMTP id KAA08646; Fri, 4 Feb 2000 10:28:23 +1100 (EST) Sender: chrisb@nimrod.itg.telstra.com.au Message-ID: <389A0EE9.3BA060D9@nimrod.itg.telecom.com.au> Date: Fri, 04 Feb 2000 10:27:37 +1100 From: Chris Bitmead Reply-To: chris@bitmead.com Organization: IBM Global Services X-Mailer: Mozilla 4.6 [en] (X11; I; SunOS 5.6 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: Taral CC: Tom Lane , Chris , Bruce Momjian , pgsql-hackers@postgreSQL.org, pgsql-sql@postgreSQL.org Subject: Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Taral wrote: > > On Thu, 3 Feb 2000, Tom Lane wrote: > > > Maintaining an accurate count of descendants (or indexes for that > > matter) would be expensive; in particular, it'd create severe > > concurrency problems. > > What about fixing these things on VACUUM then? It could produce wrong results to queries if the data is wrong.