On Tue, Sep 21, 2010 at 2:06 PM, Jens Wilke <jens@xxxxxxxxx> wrote: > On Dienstag, 21. September 2010, Aleksey Tsalolikhin wrote: >> Yesterday, I had twelve thousand "cache lookup failed for type N" >> messages, like this: > >> What does "type 14237017" mean? > > pg_type oid Dear Jens, I am trying to understand your reply. pg_type is a catalog of data types: http://www.postgresql.org/docs/8.4/static/catalog-pg-type.html An OID is a key to system table: http://www.postgresql.org/docs/8.4/static/datatype-oid.html I guess it's used to identify a row in a system table. So PostgreSQL was trying to lookup a row in a system table and did not find it in a cache. >> What cache are we talking about? > > Did you alter a type before? No. I don't even know how to alter a type. > There's a bug in postgres, that prevents the plan cache to be > invalidated on type changes. We ran into this bug as well on 8.4.4. Is there a bug id or a URL for the bug, please? I'd like to study the bug description to understand it better. Sincerely, Aleksey -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
