Re: Buglist

>>>>> "SD" == Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/