Re: Idea for vacuuming

I like to make sure the vacuum takes place during off peak times, which
is why I don't use autovacuum.

Jim Nasby wrote:
> 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(at)pervasive(dot)com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>