From: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: PG 9..5 index performance Q's
Date: Tue, 8 Nov 2016 10:31:13 -0800
Message-ID: <582219F1.9030502@nrc-cnrc.gc.ca> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi List,
running PGSQL 9.5.1 ( EL7) ,
we are seeing a issues with one of our SQL statement getting the wrong
plan once in a while ( large temp tables being generate, exec time
takes > 3 minutes compared with fastes plan < 1 min), we want to
undestand why a new/ expensive plan is been used instead of efficient
one, there are not data changes on the tables, any tips where to look?
Second , I would like to know if when re-creating one index ( non pk )
on a large table with already existing indexes, are All tables
statistics being re-generated? ( there is a way to control persistency
of old stats?)
Isabella
--
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: isabella.ghiurea@nrc-cnrc.gc.ca
Subject: Re: PG 9..5 index performance Q's
In-Reply-To: <582219F1.9030502@nrc-cnrc.gc.ca>
* 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