Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3F0669FB3B7 for ; Tue, 13 Mar 2007 14:14:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 61732-01 for ; Tue, 13 Mar 2007 14:13:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 71F159FA4CD for ; Tue, 13 Mar 2007 14:14:05 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id x4so2620173nfb for ; Tue, 13 Mar 2007 10:14:03 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=gHKcYOQsMgJufntykC6ESajy0pX3vKw+CViI6RyYvHXrCjVkixQvLzn6uTT6VW9UUh3MxfyaRFN8YHMojAO7e6OSFDhKMA/z35T14kWhKMqtciJWEr6tu+Q/24H96HwoKZy7g9Zrd0P0OSZXZhG+NbdpLxI2MRW9ouvL61COKTE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=oaUcqNriFTizZiRE9iV+IzwBjp1121B/RfFsGYc0DXJrf+3FHwIsdkqrSYQ2PaeGPZJrDH+gLOt0SWkfzOTLsxHHMVhJvFaI/t1C1USbhJdT6lfPRhaX1NpvFmzL6paDOQ4owqYXiqyidFwuyHXzn/CjpiRLRXNolwni0uxfVWc= Received: by 10.82.178.11 with SMTP id a11mr2124226buf.1173806043695; Tue, 13 Mar 2007 10:14:03 -0700 (PDT) Received: by 10.82.190.7 with HTTP; Tue, 13 Mar 2007 10:14:03 -0700 (PDT) Message-ID: <7539aebb0703131014y2512853fw9ced1bd3bb5f5e77@mail.gmail.com> Date: Tue, 13 Mar 2007 13:14:03 -0400 From: Sumeet To: pgsql-sql@postgresql.org Subject: postgres configuration MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_27306_4193230.1173806043671" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/175 X-Sequence-Number: 27813 ------=_Part_27306_4193230.1173806043671 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi All, Sorry if this is the wrong list to ask this question. My Vacuum's are running very very slow and expecially when vacuuming indexes in large tables of size in 5-10 gigabytes, can some one help me determine the parameters for postgres.conf which will help me vacuum fast. I'm running postgres on a server with 32 gigs of ram and 8 processors. Thanks, Sumeet. ------=_Part_27306_4193230.1173806043671 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi All,

Sorry if this is the wrong list to ask this question.

My Vacuum's are running very very slow and expecially when vacuuming indexes in large tables of size in 5-10 gigabytes,
can some one help me determine the parameters for postgres.conf which will help me vacuum fast. I'm running postgres on a server with 32 gigs of ram and 8 processors.


Thanks,
Sumeet. ------=_Part_27306_4193230.1173806043671--