mikeo <mikeo(at)spectrumtelecorp(dot)com> writes:
> after about 50,000 updates, which fly right along, the process begins
> to really bog down. we perform a vacuum analzye and it speeds right
> up again.
A plain "vacuum" should do the job in a bit less time. The problem
is you need to reclaim the space occupied by deleted versions of rows.
No way around that with the current storage manager: vacuum is the
only way to get rid of the wasted space.
regards, tom lane