Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zj5Mn-00088w-5l for pgsql-admin@arkaria.postgresql.org; Mon, 05 Oct 2015 12:59:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zj5Mm-0000GK-Io for pgsql-admin@arkaria.postgresql.org; Mon, 05 Oct 2015 12:59:44 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zj5Mm-0000GE-4M for pgsql-admin@postgresql.org; Mon, 05 Oct 2015 12:59:44 +0000 Received: from mail-la0-x22b.google.com ([2a00:1450:4010:c03::22b]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zj5Mj-0007eH-B6 for pgsql-admin@postgresql.org; Mon, 05 Oct 2015 12:59:42 +0000 Received: by lafb9 with SMTP id b9so36144785laf.0 for ; Mon, 05 Oct 2015 05:59:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tracelink.com; s=google; h=from:references:in-reply-to:mime-version:thread-index:date :message-id:subject:to:cc:content-type; bh=/pX7bhl1M5bpO4wxCqVUKZZv0HEqAKpvSsy+S2m2bvM=; b=kTvDX1GJeWTEO0oP3kFDnmi7qz4V6sDVh4Hy4EhO3MEbi4HWz/d2feIz5nwHftzbA2 PbLvCMS9kGFo1kbuyCKgX0wawBhK+lD5R4NpRUkvWqNP3zqowJJX+UAOg1cd0sJjzGwX YVzaDBcMXKg4d7kRYCOAWq3XdxCKbHxf4hrQ0= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:references:in-reply-to:mime-version :thread-index:date:message-id:subject:to:cc:content-type; bh=/pX7bhl1M5bpO4wxCqVUKZZv0HEqAKpvSsy+S2m2bvM=; b=Ubmlm3/fCFIsdE3HNBNp7PXS82BoYJDkOktGcyrN0qCJxqU1i8cUjoWrq6iPOpKpkS WFfEoRGurh+WxhczmMscUDdmxyLUHixwuJ4k9fhfYforBgbaBPoViIGrIRoXM3k50FTR nLID/0vYamWqQQQjKjbGykpOvWxVMlNzxKafPYzbI82QC2E6BgMbQTMAUpGIS//fFA3M 4d7h/xdvAoUbSRTftZZJbslDNxmBu+jMp64obNxvKevLyDCk7vMbDz66iW+Q7GwHKez3 trMLY0/cmYfvenOLKy3IXsQi2FPq+07hLgH8NG1hhykXW7FbMPSofqVTjAOMcAvtGaHX DA7A== X-Gm-Message-State: ALoCoQlz75tc4DiwPSP+xYfnzxshEJgZ6hKPTuYewWZCvH9LNmX1nMMQGCAF0XPtjrggzhib8MeI X-Received: by 10.25.91.4 with SMTP id p4mr7501726lfb.95.1444049979286; Mon, 05 Oct 2015 05:59:39 -0700 (PDT) From: Ben Primrose References: <560EB550.5050501@j.mk-contact.de> <23918.1443806166@sss.pgh.pa.us> <26437172ca27bd83e46c2a8db18401bb@mail.gmail.com> <4139.1443816949@sss.pgh.pa.us> In-Reply-To: <4139.1443816949@sss.pgh.pa.us> MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQIWxQJCcDKBGA0QK46lprLxdc1RiQFx9JovAZoRK4ICX7dbrZ2l82Qw Date: Mon, 5 Oct 2015 08:59:38 -0400 Message-ID: <6c446a97aa43e894916e8266c9e3d3ff@mail.gmail.com> Subject: Re: Long-running and non-finishing VACUUM ANALYZE on large table To: Tom Lane Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.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 Good to know, thanks for the response. Ben -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Friday, October 02, 2015 4:16 PM To: Ben Primrose Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Long-running and non-finishing VACUUM ANALYZE on large table Ben Primrose writes: > Tom, how'd you determine the maintenance_work_mem?