Tom, How to check if the value it's enough ? The log generate by vacuum verbose can help ?
The current values for: max_fsm_pages = 1048576 max_fsm_relations = 1000 this is enough ? Regards, Rodrigo -----Mensagem original----- De: Tom Lane [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 18 de abril de 2005 12:58 Para: Rodrigo Moreno Cc: pgsql-performance@postgresql.org Assunto: Re: [PERFORM] How to improve postgres performace "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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]