Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tldxt-0003Ic-2c for pgsql-admin@arkaria.postgresql.org; Thu, 20 Dec 2012 11:07:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tldxs-0007wf-5l for pgsql-admin@arkaria.postgresql.org; Thu, 20 Dec 2012 11:07:00 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tldxr-0007vw-3g for pgsql-admin@postgresql.org; Thu, 20 Dec 2012 11:06:59 +0000 Received: from nm1-vm0.bullet.mail.ne1.yahoo.com ([98.138.91.74]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tldxp-0008Uu-5V for pgsql-admin@postgresql.org; Thu, 20 Dec 2012 11:06:57 +0000 Received: from [98.138.90.52] by nm1.bullet.mail.ne1.yahoo.com with NNFMP; 20 Dec 2012 11:06:55 -0000 Received: from [98.138.226.166] by tm5.bullet.mail.ne1.yahoo.com with NNFMP; 20 Dec 2012 11:06:55 -0000 Received: from [127.0.0.1] by omp1067.mail.ne1.yahoo.com with NNFMP; 20 Dec 2012 11:06:55 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 928821.75661.bm@omp1067.mail.ne1.yahoo.com Received: (qmail 21181 invoked by uid 60001); 20 Dec 2012 11:06:55 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1356001615; bh=bUA8NGlD0jKWbpg44HsZloCDZMKleIUILM4iHv8zUVg=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=qoGTzqu3zQ9emuBWl4sC0pYWyZspIhYnYHJQQw/9lEg8jajv067kfT+1k4ZS2POLMG5rlvMFwDmJFQobN2WnBp0M+/N4+5YjPYxZ1B8uGFBZ6GwR/+fxdmr4nrvPGLXZFNUvNwbzP1GipqlOYCqypZ2Z/n5dsZqQvSWi0Aljqrw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=4ck4xbQd7OOotnztejcQUN03n7hMDvHgoohspoIOBpHuYrsMoW/TrNA04xjLFxgEupJ9hRKAQsX0XuVodlL5qG2EPzLwmYFI3MRXvvSsvGAw2/CRYYqxo9I+uHrmXaGHvuOXrAhBSU+0ia1rNnAMUKPd557EXp+ra6D26UTmUmw=; X-YMail-OSG: GbbUXssVM1kUC8vyHGggPOKhuKMEK7lNW2sMw.1Ac4s1Kip yMy8WUzeV6dRsQC8rrdvzrhLPedfmVIz7LmjVyqhe6JH1nkwKdPSoCNgymst XNoZlwVjMsz4xQuWXFNgWfA8PfY.ordVb9foqqwWa.X2fuMHp7FRIVhyhSOU 1YjxP0i33jWPEXMxcclW8lAc3SAmuB2Rzeif4BBlmxjuetMgoBF1ZiWE2ck7 Fq.yELwuNcfRHJf077YWdrnff7PA9e5hsi4IgJc6Fzkpe60vAk3JQU28XzO1 fJtT7FCVg0K8Ytl0Jbdj9oXZDaF4qqYKET8Hwm.7uypR2GBDXOK0z9Y1_Xlx k3nLAGnPvsW4ktkkKKk.uSyR.zJBBqRqEwGI2zB0hOy9xZAvVoS_E1lBfG5K yl2Vj93Lkj_dyEtdAD2mtDgMHUnafiMMstNLWe6AGFIiNrAxSxv9W.ju66pS 0T5IJviR1G5I_UTgM5vM5YBa8RnD08VFq5yOL Received: from [98.210.146.78] by web125905.mail.ne1.yahoo.com via HTTP; Thu, 20 Dec 2012 03:06:55 PST X-Rocket-MIMEInfo: 001.001, RGVhciBwZW9wbGVzLAoKClRvZGF5IHdlIHVwZ3JhZGVkIGEgc21hbGwgKDcuNSBtZWdhYnl0ZXMpIGJ1dCBoeXBlcmFjdGl2ZSBkYXRhYmFzZSBmcm9tIHBvc3RncmVzcWwgOS4xLjYgdG8gOS4xLjcgKHdlIHVzZSBJTkRFWCBDT05DVVJSRU5UTFkgYSBsb3QpIGFuZCBhZnRlciByZXN0YXJ0aW5nIGl0IGxvb2tzIGFzIGlmIHdlIGhhdmUgYSBzbG93ZXIgc3lzdGVtIC0tIGZld2VyIHF1ZXJpZXMsIGJ1dCBtb3JlIGxvbmcgb25lcywgZmV3ZXIgY2hlY2twb2ludHMuIEkgYW0gc3RpbGwgbWFudWFsbHkgY29tcGEBMAEBAQE- X-Mailer: YahooMailWebService/0.8.129.483 Message-ID: <1356001615.20304.YahooMailNeo@web125905.mail.ne1.yahoo.com> Date: Thu, 20 Dec 2012 03:06:55 -0800 (PST) From: Greg Williamson Reply-To: Greg Williamson Subject: Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown 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: 1.3 (+) 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 Dear peoples, Today we upgraded a small (7.5 megabytes) but hyperactive database from pos= tgresql 9.1.6 to 9.1.7 (we use INDEX CONCURRENTLY a lot) and after restarti= ng it looks as if we have a slower system -- fewer queries, but more long o= nes, fewer checkpoints. I am still manually comparing config=A0 settings to= see if anything changed (shouldn't have but ...). Has anyone else seen anything like this ? I=A0 suspect some site error had led to us scoring an own-goal but I though= t I'd ask and see if anyone else has seen this. Thanks, Greg Williamson --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin