st 2. 3. 2022 v 19:02 odesÃlatel Adam Brusselback <adambrusselb...@gmail.com> napsal:
> >In my observation, very few users require an accurate query plan for > temporary tables to > perform manual analyze. > > Absolutely not true in my observations or personal experience. It's one of > the main reasons I have needed to use (local) temporary tables rather than > just materializing a CTE when decomposing queries that are too complex for > Postgres to handle. > > I wish I could use GTT to avoid the catalog bloat in those instances, but > that will only be possible if the query plans are accurate. > This strongly depends on usage. Very common patterns from MSSQL don't need statistics. But on second thought, sometimes, the query should be divided and temp tables are used for storing some middle results. In this case, you cannot exist without statistics. In the first case, the temp tables can be replaced by arrays. In the second case, the temp tables are not replaceable. Regards Pavel
