juerg(dot)rietmann(at)pup(dot)ch wrote in message news:<OFCE7D518C(dot)69014E0E-ONC1256B4F(dot)004AE587(at)pup(dot)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