Would it be possible to rebuild all non-btree indexes when a recovery takes place?
Another thing that seems it might be nice is to check the non-btree indexes during analyze (if that is possible and not too expensive). -----Original Message----- From: Neil Conway [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 4:39 PM To: Scott Marlowe Cc: Dann Corbit; pgsql-general Subject: Re: [GENERAL] Corrupt RTREE index On Tue, 2004-12-14 at 14:12 -0600, Scott Marlowe wrote: > IS this same issue true for hash or GiST indexes? Yes, it is: currently, only btree indexes are WAL safe. (I spent some time recently looking into adding page-level concurrency and WAL to GiST, but I haven't had a chance to finish that work -- it is quite a big job...) -Neil ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
