[GENERAL] Dump / restore for optimization?

[lec]

I always have to dump & restore to make a database (which is in use for 
a few months) efficient again.  I have scheduled nightly vacuum analyze, 
but only dump & restore can make the database efficient again.  Has 
anyone experience this?

-lec
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org