i have PostgreSQL 8.1.2
i want to enable autovacuum at my PostgreSQL 8.1.2 from postgresql.conf
i've got 50-60 insert and/or update queries in a second in that case tables
shouldn't be locked
does autovacuum locks tables while vacuuming?
and also i wonder what should be the configuration?
memory: 2gb ddr2
CPU: P4-prescott 3193.495 MHz
cache size : 2048 KB
Alp UYANIK
Software Engineer