From: Matúš Svrček <svrcek@plaintext.sk>
To: Victor Yegorov <vyegorov@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: after upgrade 8.4->9.3 query is slow not using index scan
Date: Sun, 28 Sep 2014 21:24:15 +0100 (GMT+01:00)
Message-ID: <1079665306.24081411935855264.JavaMail.root@shiva> (raw)
In-Reply-To: <488838968.24061411935738421.JavaMail.root@shiva>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hello,
at the moment, I am not able to replicate the results posted. Explain analyze results are very similar at the moment on both databases, query runtime is also almost same.
This has happened after re-running VACUUM ANALYZE VERBOSE. However, right after the migration, I did run the script, which was generated by pg_upgrade script, which should have ran VACUUM on the database, the script name is analyze_new_cluster.sh.
Maybe after re-running vacuum analyze the statistics somehow changed?
Case closed, thank You.
--
Matúš Svrček
PlainText s.r.o. [www.plaintext.sk]
svrcek@plaintext.sk
----- "Victor Yegorov" <vyegorov@gmail.com> wrote:
> 2014-09-26 17:04 GMT+03:00 Matúš Svrček < svrcek@plaintext.sk > :
>
>
> I am having a performance issue after upgrade from 8.4.20-1 -> 9.3.5.
>
>
> First, make sure you have your statistics up to date — execute manual
> `VACUUM ANALYZE`.
> And then provide `EXPLAIN analyze` for 8.4 and `EXPLAIN (analyze,
> buffers)` for 9.3 output.
>
>
>
> --
> Victor Y. Yegorov
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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-performance@postgresql.org
Cc: svrcek@plaintext.sk, vyegorov@gmail.com
Subject: Re: after upgrade 8.4->9.3 query is slow not using index scan
In-Reply-To: <1079665306.24081411935855264.JavaMail.root@shiva>
* 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