- Pivotal Greenplum (GPDB) 4.3.x
- OS RHEL 6.x
When running a query, the query is failing with the following error:
ERROR: Unable to detoast datum (tuptoaster.c:260) (seg29 slice3 sdw8.gphd.local:1026 pid=530277) (cdbdisp.c:1326)
When there is no statistics on a table, a query can fail with this error message. Check pg_class table to verify if there are stats on the table.
To fix this issue all the tables in the query need to be analyzed.
To analyze a table you need to run the following on all the tables: