Re: Corrupt index

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Daryl Stultz <daryl(dot)stultz(at)opentempo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Corrupt index
Date: 2017-08-15 19:29:40
Message-ID: CAH2-WzkQk-5znC35_bVF3y7d2v4qUdN1M_YwDoD8COeX-A37Tg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 15, 2017 at 12:24 PM, Daryl Stultz
<daryl(dot)stultz(at)opentempo(dot)com> wrote:
> We have a recurring problem that we can get out of with "reindex table
> mytable". Basically we can't find a particular record or two using the
> primary key and after reindexing we can. There does seem to be a pattern
> related to application business processes but we are at a loss as to how
> this could happen.

You've given no details at all. What business pattern? What does the
index and table look like?

--
Peter Geoghegan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2017-08-15 19:48:51 Re: Corrupt index
Previous Message Daryl Stultz 2017-08-15 19:24:29 Corrupt index