2010/4/8 Merlin Moncure <mmoncure@gmail.com>:
> previous to 8.2, to get good performance on zabbix you need to
> aggressively vacuum the heavily updated tables yourself.
Generally if you DON'T vacuum aggressively enough, then vacuums will
take a really long and painful amount of time, perhaps accounting for
the "hang" the OP observed. There's really no help for it but to
sweat it out once, and then do it frequently enough afterward that it
doesn't become a problem.
...Robert