On 25/01/2014 01:01, Sergey Konoplev wrote:
On Fri, Jan 24, 2014 at 7:03 AM, Achilleas Mantzios
<achill@xxxxxxxxxxxxxxxxxxxxx> wrote:
[...]
I understand the chunk_id is the "oid" of the "value" to be toasted, is
there any way to get to the row/column
of the toasted table, faster than the aforementioned exhaustive search?
I guess there are no way to do it except the search. Try to look at
this article [1], it perfectly describes what one needs to do in such
cases as yours, and contains all the automation stuff also. Hope you
will find it useful.
[1] http://www.databasesoup.com/2013/10/de-corrupting-toast-tables.html
Very useful, Thank you!
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
