Postgres recovered from data folder , after that some queries shows error
select * from table2 order by app_id ; - its work ( 50000000 data) select * from table2 order by app_id desc ; - its work Here app_id contains binary index select * from table2 order by id ; - its work ( 50000000 data) select * from table2 order by id desc ; - shows following error manoj[local] postgres ERROR: index "tbl2_id_pkey" contains unexpected zero page at block 311121 manoj [local] postgres HINT: Please REINDEX it. index "tbl2_id_pkey" is primary key Reindex not pratical this table (250 GB data) How i can solve this ? Regards Manoj K P -- View this message in context: http://postgresql.1045698.n5.nabble.com/Primary-key-Index-Error-tp4931714p4931714.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
