Re: Vacuum thoughts - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: Vacuum thoughts
Date
Msg-id 3F92E66D.8070600@bigfoot.com
Whole thread Raw
In response to Vacuum thoughts  (Greg Stark <gsstark@mit.edu>)
Responses Re: Vacuum thoughts
List pgsql-hackers
Greg Stark wrote:
> The more I think about this vacuum i/o problem, the more I think we have it
> wrong. The added i/o from vacuum really ought not be any worse than a single
> full table scan. And there are probably the occasional query doing full table
> scans already in those systems.
> 
> For the folks having this issue, if you run "select count(*) from bigtable" is
> there as big a hit in transaction performance? On the other hand, does the
> vacuum performance hit kick in right away? Or only after it's been running for
> a bit?

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 )?


Regards
Gaetano Mendola




pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Dreaming About Redesigning SQL
Next
From: Andrew Dunstan
Date:
Subject: prioritize TODO list?