Date: Sun, 28 Sep 2014 21:24:15 +0100 (GMT+01:00)
From: =?utf-8?Q?Mat=C3=BA=C5=A1_Svr=C4=8Dek?= <svrcek@plaintext.sk>
To: Victor Yegorov <vyegorov@gmail.com>
Cc: pgsql-performance@postgresql.org
Message-ID: <1079665306.24081411935855264.JavaMail.root@shiva>
In-Reply-To: <488838968.24061411935738421.JavaMail.root@shiva>
Subject: Re: after upgrade 8.4->9.3 query is slow not using index
 scan
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hello,
at the moment, I am not able to replicate the results posted. Explain analy=
ze 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 a=
fter 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 a=
nalyze_new_cluster.sh.=20
Maybe after re-running vacuum analyze the statistics somehow changed?

Case closed, thank You.
--
Mat=C3=BA=C5=A1 Svr=C4=8Dek
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=C3=BA=C5=A1 Svr=C4=8Dek < svrcek@plaintext=
.sk > :
>=20
>=20
> I am having a performance issue after upgrade from 8.4.20-1 -> 9.3.5.
>=20
>=20
> First, make sure you have your statistics up to date =E2=80=94 execute ma=
nual
> `VACUUM ANALYZE`.
> And then provide `EXPLAIN analyze` for 8.4 and `EXPLAIN (analyze,
> buffers)` for 9.3 output.
>=20
>=20
>=20
> --
> Victor Y. Yegorov


--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance