Re: Bug in PostgreSQL - Mailing list pgsql-performance

From Joseph Curtin
Subject Re: Bug in PostgreSQL
Date
Msg-id CALmWdSh6siWFmTOep=xFs+wQNza5r3oceTXRLYWJLnovG2XTeQ@mail.gmail.com
Whole thread Raw
In response to Re: Bug in PostgreSQL  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-performance
OID is a temp-var that is only consistent within a Query Execution.


On Thu, Jun 28, 2018 at 12:50 AM, Steve Crawford <scrawford@pinpointresearch.com> wrote:


On Wed, Jun 27, 2018 at 8:31 AM Rambabu V <ram.wissen@gmail.com> wrote:
Hi Team,

While taking pgdump we are getting error message cache lookup failed for function 7418447. While trying select * from pg_proc where oid=7418447 returns zero rows. Please help us on this. 

Searching on that error messages yields a suggestion from Tom Lane to try that select with enable_indexscan and enable_bitmapscan
turned off.

This question is probably better asked in the "General" mailing list. Also please include the OS and PostgreSQL version as well as any other observations that may shed light on the issue.

Cheers,
Steve



--
-Joseph Curtin
http://www.jbcurtin.com
@jbcurtin

pgsql-performance by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Bug in PostgreSQL
Next
From: Justin Pryzby
Date:
Subject: Re: Queue table that quickly grows causes query planner to choosepoor plan