Re: When to Vacuum

Interesting...

So who/where is RelationGetNumberOfBlocks() defined, are these actual
source codes
that makeup the postgres/postmaster ?

Bruce Momjian wrote:

>Yes. The pg_stat tables do have info on the number of deleted rows,
>stuff like that. You can use that to determine the number of number of
>changes since you last vacuumed. There is also /contrib/pgstattuple
>that shows table info.
>
>---------------------------------------------------------------------------
>
>Medi Montaseri wrote:
>
>
>>I posted this on 1/20 but never got delivered....trying again....
>>
>>I was wondering if I can use any of the pg_stat* related tables to
>>determine if I
>>need to vacuum or not.
>>
>>More specifically, instead of assuming a period (based on one's usage),
>>if I was
>>to vacuum more adaptively, I could have a cron job to check certain
>>statistics table
>>every 10 minutes (or hour) and if a threashold is reached a vauum be
>>performed.
>>
>>If this is possible, please specifiy the condition for vacuum and vacuum
>>full please.
>>
>>Thanks
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>>
>>
>>
>
>
>