From: Alp UYANIK <alp@intersan.com.tr>
To: pgsql-admin@postgresql.org
Subject: autovacuum
Date: Sat, 04 Feb 2006 11:14:58 +0200
Message-ID: <6.2.1.2.2.20060204110331.03dc2eb0@81.215.12.210> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alp@intersan.com.tr
Subject: Re: autovacuum
In-Reply-To: <6.2.1.2.2.20060204110331.03dc2eb0@81.215.12.210>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox