On Sat, Oct 07, 2017 at 05:44:00AM +0200, Pavel Stehule wrote:
> 2017-10-06 21:36 GMT+02:00 Nico Williams <nico@cryptonector.com>:
> > But the nice thing about them is that you need only create them once, so
> > leave them in the catalog. Stats about them should not be gathered nor
> > stored, since they could be different per-session.
>
> Unfortunately one field from pg_class are not static - reltuples should be
> per session.
It's "only an estimate" "used by the query planner". We could estimate
zero for global temp tables, and the query planner can get the true
value from an internal temp table.
> But it can be moved to different table
That too, if it's OK.
Nico
--
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers