Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 36C647E4445 for ; Fri, 22 Jun 2012 15:59:34 -0300 (ADT) Received: from nm3.bullet.mail.sp2.yahoo.com ([98.139.91.73]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Si94v-0007DZ-2D for pgsql-admin@postgresql.org; Fri, 22 Jun 2012 18:59:33 +0000 Received: from [98.139.91.69] by nm3.bullet.mail.sp2.yahoo.com with NNFMP; 22 Jun 2012 18:59:19 -0000 Received: from [98.139.91.27] by tm9.bullet.mail.sp2.yahoo.com with NNFMP; 22 Jun 2012 18:58:19 -0000 Received: from [127.0.0.1] by omp1027.mail.sp2.yahoo.com with NNFMP; 22 Jun 2012 18:58:19 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 806688.97560.bm@omp1027.mail.sp2.yahoo.com Received: (qmail 75207 invoked by uid 60001); 22 Jun 2012 18:58:19 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1340391499; bh=11cO9TN2H58fa6FKSvFytOdXulKb5O64z7At1dEFmVI=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=6Ydutq/vhcXzw82D1xHO3buq9+zDlD762VZUqCBNrtsODnTyaQm+9cmc7BoQofFbcs5xVm8h4Z+Qc+V/joYTlgkfbaIYKATH0EFQxvkPl4A+e7zPCN7ZZ4TCy5G4xYntMgKB3kz39ZzeUyY0G1kv/fSYaAUfOUNPr2UNK1xYuuo= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Xues6gnlP+wKy5jDgnC4uhyWGkyYWedEH1bK6J1I7ZqBJC+XJwqBtzLQlbFgLdzBQgYgCuboDtCYZ8UsW/SSBfe4Ty64kKa/ZHg3iTrmoWTROuYHDLUrkLJPtDlTbJh7e/MwRdcpwUFu88AstBdHlH9Owgi/uZoG9SDpvduk1+Y=; X-YMail-OSG: baCFC.oVM1lpc_iK.JkdE.yeydUo4DlP9lMiKLvD5UwYgTQ e6THgUnGDrQX9ce5kh97v83k5Ol6PaNM8i.kEPHn.HYZvL.0s59zsbH0U4cj ikeqkMyRHBJrSL4UF8I7LS07ykfr5.96JOrayV6dIGi4uyAqK2pq0SmzAl4D _iupjiOIKRTsjB3UIjaOIYOZErrGIznK9W.h5GPkv_lqaexRYxeGhBzjf8ES hbp_pJN1s6bz0OF5A4lmxFKUR2.x8UsstCg.scI38Snws40EWs7PUiXWUX9m oCaRiHYUKkhGSLAncJJUVHzzpznl36_8jGbvc.HoNm.OTHokgZP125T168Ub 7bPyQpDfvY72j_Yv.GVWcBPHHX46ZKbAFE0unH_JgbsQjNo_z8qdtVgMmD15 ti3Q4_gLiYuD0YF4FP5Wv_gbO_LGIjI2ggEY- Received: from [98.210.146.78] by web46101.mail.sp1.yahoo.com via HTTP; Fri, 22 Jun 2012 11:58:19 PDT X-Mailer: YahooMailWebService/0.8.118.349524 Message-ID: <1340391499.61601.YahooMailNeo@web46101.mail.sp1.yahoo.com> Date: Fri, 22 Jun 2012 11:58:19 -0700 (PDT) From: Greg Williamson Reply-To: Greg Williamson Subject: autovac hitting too many tables at once To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 2.3 (++) X-Archive-Number: 201206/98 X-Sequence-Number: 39689 Hi,=0A=0AI've got an 8.4.11 system that I am relatively new to and I am see= ing multiple autovac processes kick off on several of the largest tables at= once and it is causing pain.=0A=0AAre there any suggestions to=0A=0A=A0 a)= quickly relieve the immediate pain=0A=0Aand=0A=0A=A0 b) prevent such issue= s in the future (other than going to manual vacuuming on a schedule).=0A=0A= Thanks,=0A=0AGreg Williamson=0A