[postgis-users] Got VACUUM reccomendation in newly-created postGIStable

[Per-Olof Norén]

Gregory Williamson skrev:
> Per-Olof wrote:
>   
>> kreshna_iceheart at yahoo.com skrev:
>>     
>>>  And if I run
>>> VACUUM ANALYZE, there won't be anything bad happen,
>>>   
>>>       
>> nope, do It!
>> Seriously, this is exactly the correct way to go.
>> vacuum analyze updates the index statistics.
>>
>>     
>
> Nit-picking department chimes in:
>
>  ANALYZE updates statistics for indexed columns
>
>  VACUUM cleans out dead tuples from deletes & updates and prevents table bloat and transaction id wraparound failure.
>
> So ANALYZE (which is fast and relatively light-weight) whenever data distributions change
>
> and
>
> VACUUM periodically for the whole database, and vacuum tables that have updates and deletes. Or use autovacuum if you on a recent release of PostgreSQL (8.2 seems fairly robust but your experience may differ on what sort of processing you do).
>
>   
Admittedly, I pressed send to fast. Greg is correct. :-)

cheers,
Per-Oof