RES: RES: [PERFORM] How to improve postgres performace

2005-04-18 Thread Rodrigo Moreno
> That max_fsm_pages value is enough to cover 8Gb, so it should work OK for a database disk footprint up to 10 or so Gb. > I don't know how many tables in your installation so I can't say if max_fsm_relations is high enough, but you can check >that by looking at the tail end of the output of VACUU

Re: RES: [PERFORM] How to improve postgres performace

2005-04-18 Thread Tom Lane
"Rodrigo Moreno" <[EMAIL PROTECTED]> writes: > The current values for: > max_fsm_pages = 1048576 > max_fsm_relations = 1000 > this is enough ? That max_fsm_pages value is enough to cover 8Gb, so it should work OK for a database disk footprint up to 10 or so Gb. I don't know how many tables in

RES: [PERFORM] How to improve postgres performace

2005-04-18 Thread Rodrigo Moreno
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-fe