Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TlgZe-0005hp-Q7 for pgsql-admin@arkaria.postgresql.org; Thu, 20 Dec 2012 13:54:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TlgZd-0002kf-R5 for pgsql-admin@arkaria.postgresql.org; Thu, 20 Dec 2012 13:54:09 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TlgZc-0002kZ-S9 for pgsql-admin@postgresql.org; Thu, 20 Dec 2012 13:54:08 +0000 Received: from mail-out2.uio.no ([2001:700:100:10::58]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TlgZb-00061R-1M for pgsql-admin@postgresql.org; Thu, 20 Dec 2012 13:54:08 +0000 Received: from mail-mx2.uio.no ([129.240.10.30]) by mail-out2.uio.no with esmtp (Exim 4.75) (envelope-from ) id 1TlgZa-0003tV-A2; Thu, 20 Dec 2012 14:54:06 +0100 Received: from bbking.uio.no ([129.240.6.205]) by mail-mx2.uio.no with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) user rafael (Exim 4.80) (envelope-from ) id 1TlgZZ-0007Ij-TX; Thu, 20 Dec 2012 14:54:06 +0100 Message-ID: <50D3187D.1060309@usit.uio.no> Date: Thu, 20 Dec 2012 14:54:05 +0100 From: Rafael Martinez Organization: University of Oslo User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.11) Gecko/20121116 Thunderbird/10.0.11 MIME-Version: 1.0 To: Greg Williamson CC: "pgsql-admin@postgresql.org" Subject: Re: Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown References: <1356001615.20304.YahooMailNeo@web125905.mail.ne1.yahoo.com> In-Reply-To: <1356001615.20304.YahooMailNeo@web125905.mail.ne1.yahoo.com> X-Enigmail-Version: 1.4 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-UiO-Ratelimit-Test: rcpts/h 2 msgs/h 1 sum rcpts/h 4 sum msgs/h 2 total rcpts 343 max rcpts/h 23 ratelimit 0 X-UiO-Spam-info: not spam, SpamAssassin (score=-8.0, required=5.0, autolearn=disabled, T_RP_MATCHES_RCVD=-0.01, UIO_MAIL_IS_INTERNAL=-5, UIO_PGP_SIGNED=-3, uiobl=NO, uiouri=NO) X-UiO-Scanned: E52678FA5275B11D77AB892BAE1A27CDB34E0A7C X-UiO-SPAM-Test: remote_host: 129.240.6.205 spam_score: -79 maxlevel 80 minaction 2 bait 0 mail/h: 1 total 249 max/h 23 blacklist 0 greylist 0 ratelimit 0 X-Pg-Spam-Score: -1.9 (-) 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 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/20/2012 12:06 PM, Greg Williamson wrote: > Dear peoples, > > > Today we upgraded a small (7.5 megabytes) but hyperactive database > from postgresql 9.1.6 to 9.1.7 (we use INDEX CONCURRENTLY a lot) > and after restarting it looks as if we have a slower system -- > fewer queries, but more long ones, fewer checkpoints. I am still > manually comparing config settings to see if anything changed > (shouldn't have but ...). > > Has anyone else seen anything like this ? > Hello The release notes for 9.2.2 say this: "... However, you may need to perform REINDEX operations to correct problems in concurrently-built indexes, as described in the first changelog item below....." But the 9.1.7 note says nothing about this, even when this version has the same patch for 'CREATE INDEX CONCURRENTLY' as 9.2.2 Why don't you try to reindex the indexes in your database and see it this helps? regards, - -- Rafael Martinez Guerrero Center for Information Technology University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (GNU/Linux) iEYEARECAAYFAlDTGH0ACgkQBhuKQurGihSLbQCeI1J49iLrlGcYJmiWCUnK5g8Y Ca8AnA06l9wEa2fLNRKpzktcgL4AkKBk =ygjT -----END PGP SIGNATURE----- -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin