| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: can you have any idea about toast missing chunk issu resolution |
| Date: | 2015-01-16 05:52:34 |
| Message-ID: | CAB7nPqREJdR2f+P7B+cqAkC+LuYQYyS_nHF_-m=wfgtWtrwW8w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jan 16, 2015 at 2:38 PM, M Tarkeshwar Rao
<m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com> wrote:
> Thanks Tom for your quick reply.
>
> We are using 9.1.3.
First thing: update to 9.1.18 if you do not upgrade to 9.3.5, you are
missing more than 2 years worth of bug fixes.
> You have any idea is these bugs are fixed in any release or fixed in latest 9.3.5?
> We are in blocking stage as many users depend on this. Can you please help us in resolution?
You should try what Jim has recommended upthread: first try to see if
REINDEX fixes the issue and be sure to take a file system backup. Try
as well ANALYZE as mentioned by Tom.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2015-01-16 07:39:12 | Re: Proper use of pg_xlog_location_diff() |
| Previous Message | Guillaume Lelarge | 2015-01-16 05:52:18 | Re: Information regarding Table-Locks |