Re: [GENERAL] VACUUM and fsm_max_pages

2006-07-10 Thread DANTE Alexandra
Hi Scott, hi List Thank you for your answer. I will try to launch one VACUUM FULL the next time, and I will continue to execute VACUUM between two tests. I increased max_fsm_pages until 100, but I think it's not a good solution... Regards, Alexandra Scott Marlowe wrote: On Fri, 2006

Re: [GENERAL] VACUUM and fsm_max_pages

2006-07-07 Thread Scott Marlowe
On Fri, 2006-07-07 at 01:57, DANTE Alexandra wrote: > Good morning List, > > I have seen several posts on this concept but I don’t find a complete > response. > I’m using BenchmarkSQL to evaluate PostgreSQL in transaction processing > and I work with PostgreSQL 8.1.3 on RHEL4-AS, Itanium-2 proce

[GENERAL] VACUUM and fsm_max_pages

2006-07-07 Thread DANTE Alexandra
Good morning List, I have seen several posts on this concept but I don’t find a complete response. I’m using BenchmarkSQL to evaluate PostgreSQL in transaction processing and I work with PostgreSQL 8.1.3 on RHEL4-AS, Itanium-2 processor, 8GB RAM. The database, generated via BenchmarkSQL and u