From: | Kim Applegate <kapplegate(at)apsalar(dot)com> |
---|---|
To: | David Rennalls <drennalls(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619 |
Date: | 2013-09-26 19:40:23 |
Message-ID: | CAL7VFcJYBiVLjAiXqwdAWw9noeef2tM0bj-=w_2um6b6RacA6Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I have seen this issue on a slave although it was in version 9.2. I ran
this
select 2619::regclass;
regclass
--------------
pg_statistic
(1 row)
I was able to fix my select issue by running analyze on the database
On Thu, Sep 26, 2013 at 11:47 AM, David Rennalls <drennalls(at)gmail(dot)com>wrote:
> David Fetter <david <at> fetter.org> writes:
> >
> > Upgrade to 9.1.3 and let us know whether that fixes the problem.
>
> I've run into this issue as well on postgres 8.4.14. Aside from upgrading
> to a
> newer release is there any manual fixup that can be done ?
>
> Thanks,
> David
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
From | Date | Subject | |
---|---|---|---|
Next Message | David Rennalls | 2013-09-26 20:19:20 | Re: select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619 |
Previous Message | David Rennalls | 2013-09-26 18:47:03 | Re: select table indicate missing chunk number 0 for toast value 96635 in pg_toast_2619 |