Re: Possible index issue on 9.5 slave - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Possible index issue on 9.5 slave
Date
Msg-id CAM3SWZSNfnNKCsFF5jFbZXuXrk8tKNdHMM+75J5P9bUNXPHi_Q@mail.gmail.com
Whole thread Raw
In response to Possible index issue on 9.5 slave  (Ian Barwick <ian@2ndquadrant.com>)
Responses Re: Possible index issue on 9.5 slave  (Ian Barwick <ian@2ndquadrant.com>)
List pgsql-hackers
On Wed, Jun 18, 2014 at 6:54 PM, Ian Barwick <ian@2ndquadrant.com> wrote:
> I've just run into an index issue on 9.5 HEAD on a slave (master and slave
> both compiled from 66802246e22d51858cd543877fcfddf24e6812f2); details
> below (I have only found one index on the slave where the issue occurs so far).

Would you mind running my btreecheck tool on both systems? That might
shed some light on this. You can get it from:
http://www.postgresql.org/message-id/CAM3SWZRtV+xmRWLWq6c-x7czvwavFdwFi4St1zz4dDgFH4yN4g@mail.gmail.com
.

I suggest running bt_parent_index_verify() and bt_leftright_verify()
on all indexes on both systems. It shouldn't take too long.

Thanks
-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: delta relations in AFTER triggers
Next
From: Joe Conway
Date:
Subject: Re: [bug fix] Memory leak in dblink