Philip Molter wrote:
>
> table). We also recreate the indices on the most frequent table every
> 12 hours, since vacuum doesn't clean up after indices (again, it
> appears).
>
Are you sure about that? Since an index grows with each insert or
update they would soon take up the whole disk for any active databases.
I see in my postgres log:
DEBUG: Index ml_pkey: Pages 882; Tuples 174067: Deleted 18. CPU
0.07s/0.62u sec.
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com
