[GENERAL] Corrupt index

2017-08-15 Thread Daryl Stultz
ardware. If such a thing cannot be done with transactions, statements, and queries alone, what should we be looking at for settings? Thanks. -- Daryl Stultz Principal Software Developer _ OpenTempo, Inc http://www.opentempo.com<http://www.open

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 tha

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 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