Re: Bug in PostgreSQL

Поиск
Список
Период
Сортировка
От Joseph Curtin
Тема Re: Bug in PostgreSQL
Дата
Msg-id CALmWdSh6siWFmTOep=xFs+wQNza5r3oceTXRLYWJLnovG2XTeQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bug in PostgreSQL  (Steve Crawford <scrawford@pinpointresearch.com>)
Список 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 по дате отправления:

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: Bug in PostgreSQL
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Queue table that quickly grows causes query planner to choosepoor plan