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