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]

Reply via email to