Re: Vacuum thoughts - Mailing list pgsql-hackers

From Shridhar Daithankar
Subject Re: Vacuum thoughts
Date
Msg-id 3F936DC1.9070307@persistent.co.in
Whole thread Raw
In response to Re: Vacuum thoughts  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: Vacuum thoughts
List pgsql-hackers
Gaetano Mendola wrote:
> The vacuum cost is the same of a full scan table ( select count(*) ) ?
> Why not do a sort of "vacuum" if a scan table happen ( during a simple
> select that invole a full scan table for example )?

I was thinking about it. How about vacuuming a page when it is been pushed out 
of postgresql buffer cache? It is is memory so not much IO is involved.

Could it be an approach?
 Shridhar



pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Dreaming About Redesigning SQL
Next
From: Josh Berkus
Date:
Subject: Re: Dreaming About Redesigning SQL