On Wed, Dec 15, 2004 at 10:22:31 +1100, "Harvey, Allan AC" <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm after suggestions on how to keep the initial performance > of a system I've put together for longer than 2 minutes. > > I have a small table about 20 rows, a constant, that is receiving > about 160 updates per second. > The table is used to share gathered data to other process asynchronously. > After 5 min it is 12 updates per second. > Performance returns after a vacuum analyse.
You should vacuum that table after a very short period of time. From your description, I would guess that you want to vacuum it at least once a minute, probably more often if the vacuum itself doesn't slow things down too much. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
