Michael Guerin <guerin@xxxxxxxxxx> writes: > Ok, so I'm trying to track down the rows now (big table slow queries :( > ) How does one zero out a corrupt row, plain delete? I see references > for creating the missing pg_clog file but I don't believe that's what > you're suggesting.. Zeroing out the whole block containing it is the usual recipe. I forget the exact command but if you trawl the archives for mention of "dd" and "/dev/zero" you'll probably find it. Keep in mind you want to stop the postmaster first, to ensure it doesn't have a copy of the bad block cached in memory. regards, tom lane
