"Mark Steben" <msteben@xxxxxxxxxxxxxxx> writes: > Hi folks, getting this error in production: > unexpected chunk number 0 (expected 1) for toast value 34761 What PG version is that? It looks like it might be an index-corruption issue, in which case reindexing the toast table might help. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match