Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WJVCO-0002Ys-FP for pgsql-admin@arkaria.postgresql.org; Fri, 28 Feb 2014 21:42:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WJVCN-00072p-Vz for pgsql-admin@arkaria.postgresql.org; Fri, 28 Feb 2014 21:42:28 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WJVCN-00072j-0m for pgsql-admin@postgresql.org; Fri, 28 Feb 2014 21:42:27 +0000 Received: from nm48.bullet.mail.ne1.yahoo.com ([98.138.120.55]) by makus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WJVCJ-00061F-Ey for pgsql-admin@postgresql.org; Fri, 28 Feb 2014 21:42:26 +0000 Received: from [127.0.0.1] by nm48.bullet.mail.ne1.yahoo.com with NNFMP; 28 Feb 2014 21:42:22 -0000 Received: from [98.138.101.132] by nm48.bullet.mail.ne1.yahoo.com with NNFMP; 28 Feb 2014 21:39:40 -0000 Received: from [98.138.89.233] by tm20.bullet.mail.ne1.yahoo.com with NNFMP; 28 Feb 2014 21:39:40 -0000 Received: from [127.0.0.1] by omp1048.mail.ne1.yahoo.com with NNFMP; 28 Feb 2014 21:39:40 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 691307.10801.bm@omp1048.mail.ne1.yahoo.com Received: (qmail 58832 invoked by uid 60001); 28 Feb 2014 21:39:40 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1393623580; bh=s+6YkssLnYUFJpywtexXU94QhppWGdELq0JJx21p/RM=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=3OVZs712aNQH4hqIPXQc7BP3eQrZ8jrffPmwNm6O/4Ub477LmCnOr58ouvRmS8IjkVH5LTmgjObivPvduB+SBG4axwteTHHDjSg9dh4aR546lzRqchd9HOtZtFNJPqgLOXhRLyLh1cN8CGi1Qc6jWK3fCstxYv06i/LZLv7I4eQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=gntSLtcX6X/cFSKdQ6k+tE7r7+Gpsr+t1R2sq0Wxs3A6A/T2NAnsZe7VTKQaAmPda1lIiOFlSQdUv3QHVWlqWyUizvH0vC5hw9eI9CCvKnOb1y79ax2wukZoVJQBWBDsi7s+399Unz2Df7ISSP3ABnIkNSzV2+2J3GLkxH9b/Y4=; X-YMail-OSG: pTsjCZ4VM1l8KWwXViuxAq3Mblb2ySYSwwpccHN8OoqELRT hCYh7GewNyekw8ZIOROrstKjSkl.IA23uqxH84UKjTbvr02xWq_HShKVcQFw 4yZK64SulM9w9WabgWLvtmWZ67b2dzmsvGnqRoJ96CgI0qOUgq2HoxiCUhsM jrY.d31iKzN.HfqIvX8MQt7pOHJ5.WK.Bb6FfAbF4FeeSuJlwhRp.oApgQN7 C6vjHZcnjeVql1qzNkwIC32A6UUXld42sUElFq07OX7T_s96JmqyivzAOjid SJ1X8sjqiLmHl_cb2jUy6Hp1fZ6ZbIFhVCXdHatWkN8MqHL1r3AgUNGKluQz GcZcjvd0Hhe9P_i3IUB.CKqe8PunPNyPR0S0lyyvSXN6BtpDJyROCyE4_vzH JmPXA4SPgbpaJI9j5jxYKPcKVp1GB_GMI6OqPQ4dKTVCT.QNqRysnysnRGh1 F8EvarFD34EeionsTCJviWi7U8NJPelFLaSWCzKOm0g6NNmWAdipnhuS3oxW vaMbUN_33g9a5gHIVTt3x82GQIxzcIC1gLirLNx.in87Z_BQwfbALt2L4Rre 8XQuaC5gKfJ9tO9CYlDiZg3hYueX9bSLnEc0s322JTGCfJQR2JIs- Received: from [24.178.25.147] by web122303.mail.ne1.yahoo.com via HTTP; Fri, 28 Feb 2014 13:39:40 PST X-Rocket-MIMEInfo: 002.001, Implc3BlckBrcm9naC5jYyIgPGplc3BlckBrcm9naC5jYz4gd3JvdGU6Cgo.IFRoZSBkYXRhYmFzZSBpcyBhIGxhcmdlIGRhdGFiYXNlICgzVEIrKSBhbmQgSSBoYXZlIDIwMCsgYmFja2VuZAo.IHByb2Nlc3NlcyBwb2xsaW5nIGEgbWVzc2FnZSBxdWV1ZXRhYmxlIGZvciB3b3JrIHRvIGRvLiBPbiB0aGlzIG1lc3NhZ2UKPiBxdWV1ZSB0YWJsZSwgd2hlbiBhY3Rpdml0eSByaXNlcyBhdXRvdmFjdXVtIGZhaWxzIHRvIG1ha2UgcHJvZ3Jlc3MgYW5kIEkKPiBjYW5ub3QgZ2V0IHdoYXQgaXMgYWN0dWFsbHkgaG8BMAEBAQE- X-Mailer: YahooMailWebService/0.8.177.636 References: Message-ID: <1393623580.65625.YahooMailNeo@web122303.mail.ne1.yahoo.com> Date: Fri, 28 Feb 2014 13:39:40 -0800 (PST) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: Autovacuum progressing slow (with high activity on the system). To: "jesper@krogh.cc" , "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org "jesper@krogh.cc" wrote: > The database is a large database (3TB+) and I have 200+ backend > processes polling a message queuetable for work to do. On this message > queue table, when activity rises autovacuum fails to make progress and I > cannot get what is actually holding it back What version is this, as shown by the version() function? -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin