pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown
3+ messages / 2 participants
[nested] [flat]
* Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown
@ 2012-12-20 11:06 Greg Williamson <gwilliamson39@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Greg Williamson @ 2012-12-20 11:06 UTC (permalink / raw)
To: pgsql-admin
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 ?
I suspect some site error had led to us scoring an own-goal but I thought I'd ask and see if anyone else has seen this.
Thanks,
Greg Williamson
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown
@ 2012-12-20 13:54 Rafael Martinez <r.m.guerrero@usit.uio.no>
parent: Greg Williamson <gwilliamson39@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Rafael Martinez @ 2012-12-20 13:54 UTC (permalink / raw)
To: Greg Williamson <gwilliamson39@yahoo.com>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Upgrade from 9.1.6 to 9, 1.7 seems to have caused a major slowdown
@ 2012-12-20 22:12 Greg Williamson <gwilliamson39@yahoo.com>
parent: Rafael Martinez <r.m.guerrero@usit.uio.no>
0 siblings, 0 replies; 3+ messages in thread
From: Greg Williamson @ 2012-12-20 22:12 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
Rafael --
<...>
>> 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
Thanks for the suggestion -- I did indeed a lot of time on checking indexes.
But of course it was not postgres at all, just servers that hadn't dealt well with the brief outage.
The upgraded instance is performing just as expected.
Thanks & sorry for wasting time of the list, wee hours of the morning and a sense of desperation.
GW
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-12-20 22:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-12-20 11:06 Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown Greg Williamson <gwilliamson39@yahoo.com>
2012-12-20 13:54 ` Rafael Martinez <r.m.guerrero@usit.uio.no>
2012-12-20 22:12 ` Re: Upgrade from 9.1.6 to 9, 1.7 seems to have caused a major slowdown Greg Williamson <gwilliamson39@yahoo.com>
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