Yan Chunlu <springrider@xxxxxxxxx> writes: > oh god...thanks a lot for the tip. I did actually lost some data, the > master server has crashed two times. every time it comes back, the > index were broken. I need to reindex it. I have already set fsync=on. > just thought it was normal behavior.... Uh, no. > about gcc version, only 4.6.0 effected? 4.6.1 is okay? then I could > compile my own version with 4.6.1 It's supposed to be fixed in 4.6.1 according to http://gcc.gnu.org/bugzilla/show_bug.cgi?id=49390 Personally I'd use 4.6.1 *and* apply the Postgres patch. 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