I have had to bump the stats on a partitioned table in order to get the
planner to use an index over a seqscan. This has worked well in making
the system perform where it needs to as it reduced one query's execution
from > 45 seconds to < 1 second.
The one problem I have run into is that when I create a new child table
/ table partition, the stats value (attstattarget in pg_attribute) does
not get carried over from the parent - instead the system default (-1)
is set. Is it supposed to behave this way - meaning that I need to
explicitly define the custom value for each child table? Or is there a
way for this to be implicitly copied when the child table is created?
I prefer not to change the system default on all the tables in the
database because the value needs to be increased for one case.
Thanks,
Kevin