Re: Degrading performance

"Mindaugas Riauba" <mind@bi.lt> writes:
>   I have table with slowly degrading performance. Table is special is
> such way that all its rows are updated every 5 minutes (routers interfaces).
> vacuum does not help. vacuum full does but I'd like to avoid it.

VACUUM will do the trick, you just need to do it every five minutes or
so.  I suggest a cron job to vacuum just the one table.

> INFO:  Rel ifdata: Pages: 4887 --> 17; Tuple(s) moved: 776.
>         CPU 0.30s/0.35u sec elapsed 1.65 sec.

That says you waited way too long to vacuum --- over two hundred update
cycles, evidently.

            regards, tom lane