| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Paul Ramsey <pramsey(at)cleverelephant(dot)ca>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com>, James Sewell <james(dot)sewell(at)lisasoft(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Andreas Ulbrich <andreas(dot)ulbrich(at)matheversum(dot)de> |
| Subject: | Re: Choosing parallel_degree |
| Date: | 2016-04-12 12:53:56 |
| Message-ID: | CA+TgmoZPJdHKE2R1YSU6HAZUWn7=T0_-OwjQ6FOSsTdfS0TASA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Apr 11, 2016 at 5:45 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On 8 April 2016 at 17:49, Robert Haas <robertmhaas(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2016-04-12 13:00:57 | Re: [HACKERS] Breakage with VACUUM ANALYSE + partitions |
| Previous Message | tushar | 2016-04-12 12:52:13 | Re: Choosing parallel_degree |