ANALYZE fails with “value out of range: overflow” on tables containing extreme float8 values
search cancel

ANALYZE fails with “value out of range: overflow” on tables containing extreme float8 values

book

Article ID: 422717

calendar_today

Updated On:

Products

VMware Tanzu Greenplum VMware Tanzu Data Suite VMware Tanzu Data Suite VMware Tanzu Greenplum / Gemfire

Issue/Introduction

When running ANALYZE (or VACUUM ANALYZE) on a table that contains a float8 (double precision) column, the operation may fail with the following error:

ERROR: value out of range: overflow

Environment

GPDB 6.30.0

Resolution

Please contact Broadcom Tanzu Support.