juerg.rietmann@pup.ch wrote in message news:<OFCE7D518C.69014E0E-ONC1256B4F.004AE587@pup.ch>...
> Hello there
>
> > Please help me in analyzing this output. After vacuum/analyze, the
> performance is ok for another month.
>
Are you regularily doing a "vacuum analyze"? This is a critical step
to maintaining the database as PostgreSQL doesn't re-use
deleted/updated tuples. In order to keep the db queries fast within
PostgreSQL, you'll need to regularily perform a "vacuum analyze". The
frequency will depend on how often the database has
updated/deleted/inserted tuples.
HTH,
-Tony
