[PERFORM] Slow UPDATE in logs that's usually fast

Hello, There's a slow UPDATE query in my logs (~60s). However, when I run it manually, it's really fast ( < 0.5ms). 2016-11-23 18:13:51.962 GMT [742-25]: bpd_production bpd@web001(40916) 0 Passenger RubyApp: /var/www/bpd/current (production) LOG: duration: 59876.947 ms statement: UPDATE "co

Re: [PERFORM] Millions of tables

Greg, sorry for the resent: I had forgotten to include the list. On Wed, Oct 5, 2016 at 2:34 PM, Greg Spiegelberg wrote: > Data is not static. The 4M tables fall into one of two groups. > > Group A contains 2M tables. INSERT will occur ~100 times/day and maximum > number of records anticipated