"Rodrigo Moreno" <[EMAIL PROTECTED]> writes: > At this weekend i have started to use pg_autovacuum with default settings.
> I really worried about that, because it's no enough anymore, and users claim > about performace. But running the vacuumdb full, everthing starts to run > better again, so i think the problem is not related to a specific query. It sounds like you may not have the FSM settings set large enough for your database. The default settings are only enough for a small DB (perhaps a few hundred meg). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings