Re: Vacuum thoughts

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Vacuum thoughts
Date: 2003-10-20 05:08:17
Message-ID: 3F936DC1.9070307@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2003-10-20 05:19:00 Re: Dreaming About Redesigning SQL
Previous Message Christopher Browne 2003-10-20 02:47:29 Re: Dreaming About Redesigning SQL