hubert depesz lubaczewski <depesz@xxxxxxxxxx> writes: > OK. So based on it all, it looks like for some rows, first two columns got mangled. Good detective work. So now we at least have a believable theory about *what* is happening (something is stomping the first 8 data bytes of these particular rows), if not *why*. You said that pg_dump does not show the corruption. That could be because the data is coming out through the COPY code path instead of the SELECT code path. Could you try a pg_dump with --inserts (which will fetch the data with SELECTs) and see if it shows corrupt data? Another thing we probably should ask at this point is whether you have any nonstandard software loaded into your server, like auto_explain or pg_stat_statements or some such. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
