Re: Idea for vacuuming

On Jun 22, 2006, at 7:12 PM, Joseph Shraibman wrote:
> I'm running a 8.0 database.  I have a very large log table that is  
> rarely updated or deleted from.  The nightly vacuum does not know  
> this, and spends a lot of time on it, and all its indexes.
>
> My RFE: When vacuuming a table, pg should try to vacuum the primary  
> key first.  If that results in 0 recovered entries, then assume the  
> table has no updates/deletes and skip the rest of that table.  I'm  
> picking the primary key here, but any index that indexes each row  
> of the table will do.  Maybe it should just pick the smallest index  
> that indexes each row of the table.

*shrug* It's kinda hard to get excited about that when running  
autovacuum (or pg_autovacuum in the case of 8.0) would be a much  
better solution.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461