Postgres Pro
Downloads
Home   >   mailing lists

autovacuum - Mailing list pgsql-admin

From Alp UYANIK
Subject autovacuum
Date
Msg-id 6.2.1.2.2.20060204110331.03dc2eb0@81.215.12.210
Whole thread Raw
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: su-like behavior
Next
From: Christopher Browne
Date:
Subject: Re: autovacuum