Postgres 9.6 on Windows 10
I'm creating a table
filtered_table1 via a simple select operation on another table
table1 (around 1.8 billion rows) and filtering it by some field
create table filtered_table1 as ( select * from table1 where epoch_time >= 1510227000000 and epoch_time <= 1510230600000 );
I get the error pasted below on running this query after sometime.
ERROR: could not read block 4585496 in file "base/16393/1949151.34": Invalid argument SQL state: XX000
I followed some suggestions especially the one given here where it was suggested to try setting
zero_damaged_pages = on in
postgresql.conf file. I continue to get this error even after doing this. Request help on finding and fixing this issue. Note: I have other tables in the same database and do not see such error while working with those.