On Tue, Aug 15, 2017 at 12:24 PM, Daryl Stultz <daryl.stultz@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general