>>>>> "SD" == Shridhar Daithankar <shridhar_daithankar@persistent.co.in> writes:
SD> On Tuesday 19 August 2003 21:03, Vivek Khera wrote:
>> Tops on my wish list is that postgres automatically notice when a row
>> is no longer needed (all transactional references to it are gone) and
>> 'free' it at that time, rather then needing a special scan to
>> determine the row is no longer needed and freeing it.
SD> Heh.. we have autovacuum right. Well it does not work the way you
SD> want but it works automatically at least.
There's a big difference between "noticing that a table needs to be
vacuumed and running it" and "automatically having the backend free a
row as soon as we know it is eligible to be (as would normally be
determined by vacuum)".
One of these days when I can afford a 14-hour dump/restore, I'll
upgrade to 7.4 and try autovacuum :-)
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/