Horton

Re: Vacuum thoughts

Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

View thread View on postgr.es
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2003-10-20T05:08:17Z
Lists: 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