lec wrote:
> 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?
You could try several things if you want to avoid dump/restore
- Try vacuum full instead of vacuum analyze
- Postgresql versions pre-7.4 had index bloat with vacuum. 7.4.x fixed this. So
try with that.
- Run autovacuum daemon if possible.
HTH
Shridhar