Re: [GENERAL] Corrupt index

2017-08-15 Thread Daryl Stultz
On 8/15/2017 1:07 PM, Andreas Kretschmer wrote: >> I only wanted to exclude it. Anyway, you should install the latest patches. >he can't, with RDS, he's at the mercy of Amazon for all sysadmin duties. For many things, yes. I do have options to upgrade PG. We could probably do a minor upgrade

Re: [GENERAL] Corrupt index

2017-08-15 Thread John R Pierce
On 8/15/2017 1:07 PM, Andreas Kretschmer wrote: I only wanted to exclude it. Anyway, you should install the latest patches. he can't, with RDS, he's at the mercy of Amazon for all sysadmin duties. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-

Re: [GENERAL] Corrupt index

2017-08-15 Thread Andreas Kretschmer
On 15 August 2017 21:54:56 GMT+02:00, Daryl Stultz wrote: > >>>We are using PostgreSQL 9.3.14 on a managed Amazon RDS with a > > >>Are you using reindex concurrently? There was a bugfix in 9.3.16 (+-1, >i'm not sure). > >Hi Andreas, not that I'm aware of. I issue "reindex table mytable" to >get o

Re: [GENERAL] Corrupt index

2017-08-15 Thread Daryl Stultz
>>We are using PostgreSQL 9.3.14 on a managed Amazon RDS with a >Are you using reindex concurrently? There was a bugfix in 9.3.16 (+-1, i'm not >sure). Hi Andreas, not that I'm aware of. I issue "reindex table mytable" to get out of the bad situation. I'm not sure if you are saying this bug c

Re: [GENERAL] Corrupt index

2017-08-15 Thread Daryl Stultz
On Tue, Aug 15, 2017 at 12:24 PM, Daryl Stultz >>You've given no details at all. What business pattern? What does the >>index and table look like? Hi Peter. There are no details that are obvious to me that I should be providing. The business process is one of a thousand that the application

Re: [GENERAL] Corrupt index

2017-08-15 Thread Andreas Kretschmer
On 15 August 2017 21:24:29 GMT+02:00, Daryl Stultz wrote: >Hello, > >We are using PostgreSQL 9.3.14 on a managed Amazon RDS with a > Are you using reindex concurrently? There was a bugfix in 9.3.16 (+-1, i'm not sure). Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company --

Re: [GENERAL] Corrupt index

2017-08-15 Thread Peter Geoghegan
On Tue, Aug 15, 2017 at 12:24 PM, Daryl Stultz 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 applicatio

[GENERAL] Corrupt index

2017-08-15 Thread Daryl Stultz
Hello, We are using PostgreSQL 9.3.14 on a managed Amazon RDS with a Multi-zone failover configuration. We do not have access to the hardware or file system. Fsync is enabled. We have a recurring problem that we can get out of with "reindex table mytable". Basically we can't find a particular