Re: global temporary tables
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Greg Sabino Mullane <greg@turnstep.com>, pgsql-hackers@postgresql.org
Date: 2010-04-24T18:41:11Z
Lists: pgsql-hackers
> > 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