On Mon, Apr 11, 2016 at 5:45 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On 8 April 2016 at 17:49, Robert Haas <robertmhaas@gmail.com> wrote:
>> With the patch, you can - if you wish - substitute
>> some other number for the one the planner comes up with.
>
> I saw you're using AccessExclusiveLock, the reason being it affects SELECTs.
>
> That is supposed to apply when things might change the answer from a SELECT,
> whereas this affects only the default for a plan.
>
> Can I change this to a lower setting? I would have done this before applying
> the patch, but you beat me to it.
I don't have a problem with reducing the lock level there, if we're
convinced that it's safe.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company