> > For a first cut, I had thought about ignoring the problem. Now, that > may sound stupid, because now if two different backends have very > different distributions of data in the table and both do an ANALYZE, > one set of statistics will clobber the other set of statistics. On > the flip side, for some usage patterns, it might be actually work out > to a win. Maybe the data I'm putting in here today is a great deal > like the data I put in here yesterday, and planning it with > yesterday's statistics doesn't cost enough to be worth a re-ANALYZE. >
Both variant can be. First time - statistic can be taken from some "original" (can be empty). After ANALYZE the statistic can be individual. Regards Pavel -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
