X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DC3309DC850 for ; Sat, 4 Feb 2006 11:06:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83224-09 for ; Sat, 4 Feb 2006 11:06:57 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id D6FB69DC84E for ; Sat, 4 Feb 2006 11:06:50 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k14F6m5A009618 for ; Sat, 4 Feb 2006 15:06:48 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k14F2xjl009262 for pgsql-admin@postgresql.org; Sat, 4 Feb 2006 11:02:59 -0400 (AST) (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: autovacuum Date: Sat, 04 Feb 2006 06:54:30 -0800 Organization: cbbrowne Computing Inc Lines: 21 Message-ID: References: <6.2.1.2.2.20060204110331.03dc2eb0@81.215.12.210> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, berkeley-unix) Cancel-Lock: sha1:ILIntMxd6p3ENArMvmberbxbB2E= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-0.881 required=5 tests=[ALL_TRUSTED=-1.44, AWL=-0.254, INFO_TLD=0.813] X-Spam-Score: -0.881 X-Spam-Level: X-Archive-Number: 200602/36 X-Sequence-Number: 20457 > 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? Of course it does; any request to access a relation will issue one or more locks on the relation. VACUUM issues an AccessShareLock request against each relation that is vacuumed, which is probably nearly the same lock request your applications will be requesting, save for the fact that they'll also be submitting some RowExclusiveLock requests for individual rows of relations. http://www.postgresql.org/docs/8.1/interactive/mvcc.html -- let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;; http://linuxdatabases.info/info/nonrdbms.html "Bother," said Pooh, as he deleted his root directory.