autovacuum

From: Alp UYANIK <alp(at)intersan(dot)com(dot)tr>
To: pgsql-admin(at)postgresql(dot)org
Subject: autovacuum
Date: 2006-02-04 09:14:58
Message-ID: 6.2.1.2.2.20060204110331.03dc2eb0@81.215.12.210
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Browne 2006-02-04 14:54:30 Re: autovacuum
Previous Message Alvaro Herrera 2006-02-04 04:04:05 Re: su-like behavior