Re: Shared invalidation cache messages for temporary tables

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Shared invalidation cache messages for temporary tables
Date: 2011-03-14 08:34:20
Message-ID: 1300091660.1790.7644.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 2011-03-11 at 20:44 -0500, Bruce Momjian wrote:
> Looking at the code, it seems we create shared invalidation messages for
> temporary table activity? Is this true? Should we be avoiding it?
>
> I tested this by reviewing the code and checking calls to
> CacheInvalidateHeapTuple(), which happens for temporary table
> creation/destruction.

Yes, that gets called.

But in PrepareForTupleInvalidation() we ignore everything apart from
system relations, as the first check.

--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2011-03-14 09:18:11 Re: Indent authentication overloading
Previous Message Simon Riggs 2011-03-14 08:22:59 Re: Macros for time magic values