Bruce Momjian <[email protected]> wrote: > I think we have two choices --- either migrate the statistics, or > adopt my approach to generating incremental statistics quickly. > Does anyone see any other options? Would it make any sense to modify the incremental approach to do a first pass of any tables with target overrides, using the default GUC setting, and then proceed through the passes you describe for all tables *except* those? I'm thinking that any overrides were probably set because the columns are particularly important in terms of accurate statistics, and that running with different GUC settings will just be a waste of time for those tables -- if they have a high setting for any column, they will sample more blocks for every run, right? -Kevin
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
