From: Rafael Martinez <r.m.guerrero@usit.uio.no>
To: Greg Williamson <gwilliamson39@yahoo.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown
Date: Thu, 20 Dec 2012 14:54:05 +0100
Message-ID: <50D3187D.1060309@usit.uio.no> (raw)
In-Reply-To: <1356001615.20304.YahooMailNeo@web125905.mail.ne1.yahoo.com>
References: <1356001615.20304.YahooMailNeo@web125905.mail.ne1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
-----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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: r.m.guerrero@usit.uio.no, gwilliamson39@yahoo.com
Subject: Re: Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown
In-Reply-To: <50D3187D.1060309@usit.uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox