[EMAIL PROTECTED] wrote in message news:<[EMAIL PROTECTED]>... > 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
