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 8B39411F662C for ; Wed, 29 Mar 2006 06:06:38 -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 87225-01 for ; Wed, 29 Mar 2006 06:06:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.195]) by postgresql.org (Postfix) with ESMTP id 6100211F663A for ; Wed, 29 Mar 2006 06:06:36 -0400 (AST) Received: by zproxy.gmail.com with SMTP id i11so128992nzh for ; Wed, 29 Mar 2006 02:06:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=URlMa3AxFgkCLNBFXHgUz0jCjju4VQZccoHuKoNNf8YbQf0wJw/ItTZXC+fgVREuBMrULQsyVmgW5KKC7sOWb8JwPHU8+LmeICwTmTEKy1e7ircM5GQMglwu9kFVMI0h/fGW80Zj1o9WHzxhIXAXJOeYszTe4R0kbmK+p66RDSQ= Received: by 10.36.220.38 with SMTP id s38mr758738nzg; Wed, 29 Mar 2006 02:06:36 -0800 (PST) Received: by 10.36.71.8 with HTTP; Wed, 29 Mar 2006 02:06:36 -0800 (PST) Message-ID: <674d1f8a0603290206u55f114e1y7bfc2f83696fbada@mail.gmail.com> Date: Wed, 29 Mar 2006 15:36:36 +0530 From: "Gourish Singbal" To: "pgsql-admin@postgresql.org" Subject: auto vacuuming MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_18985_31812954.1143626796239" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.345 required=5 tests=[AWL=-0.108, HTML_FONT_FACE_BAD=0.452, HTML_MESSAGE=0.001] X-Spam-Score: 0.345 X-Spam-Level: X-Archive-Number: 200603/334 X-Sequence-Number: 21091 ------=_Part_18985_31812954.1143626796239 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline we are using postgresql 8.1.3 and wanted to enable autovacuuming for only one of the many databases on the same postgresql cluster. pg_autovacuum seems to allow to ignore only a particular table and not the database since column vacrelid is OID from pg_class table Are there any suggestions to accomplish this tasks?. -- Best, Gourish Singbal ------=_Part_18985_31812954.1143626796239 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
we are using postgresql 8.1.3 and wanted to enable aut= ovacuuming for only one of the many databases on the same postgresql cluste= r.
pg_autovacuum seems to allow to ignore only a particul= ar table and not the database since column vacrelid is OID from pg_class ta= ble  Are there any suggestions to accomplish this tasks?.<= /div>
 
 


--
Best,
Gourish Singbal
------=_Part_18985_31812954.1143626796239--