Re: Not HOT enough

Excerpts from Robert Haas's message of mié nov 23 12:28:38 -0300 2011:

> Hmm, I'm not seeing any increase in the number of entries in
> pg_shdepend when I create either a temporary or permanent table:
>
> rhaas=# select sum(1) from pg_shdepend;
>  sum
> -----
>    2
> (1 row)
>
> rhaas=# create temp table xyz (a int);
> CREATE TABLE
> rhaas=# select sum(1) from pg_shdepend;
>  sum
> -----
>    2
> (1 row)

That's because the owner is "pinned" (i.e. the bootstrap user).  Try
with a different user.  I see new rows with both temp and non-temp
tables.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support