On 21/09/2013, at 00.01, Jeff Janes wrote:
> See "In progress INSERT wrecks plans on table" and "Performance bug in
> prepared statement binding in 9.2" also on this list
This feels like the same
http://postgresql.1045698.n5.nabble.com/Slow-query-plan-generation-fast-query-PG-9-2-td5769363.html
On Thu, Sep 19, 2013 at 5:49 PM, Bartłomiej Romański wrote:
>
> Finally, we created a python script to make simple queries in a loop:
>
> while True:
> id = random.randrange(1, 1000 * 1000)
> db.execute('select offers.id, offers.name, categories.id,
> categories.name from offers left join
We haven't seen any issues since we decreased shared_buffers. We also
tuned some of the longer running / more frequently executed queries, so
that may have had an effect as well, but my money would be on the
shared_buffers change. If the issue re-appears I'll try to get a perf
again and post back
