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(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support