Re: Deadlock between concurrent index builds on different tables

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Jeremy Finzel <finzelj(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deadlock between concurrent index builds on different tables
Date: 2017-12-27 00:43:03
Message-ID: 20171227004303.GB1727@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 27, 2017 at 12:27:05AM +0100, Alban Hertroys wrote:
>
>> On 26 Dec 2017, at 18:11, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
>
> …
>
> > 3. configure and make
> > ./configure <configure options>
> > make
> > make install
>
> …
>
> > For the options in step 3 you could use whatever your current server
> > has; use "pg_config --configure" to find these out. You're gonna need
> > same flags if you want to use your existing data directory.
>
> Does that mean that at step 3 one could issue this?:
>
> ./configure `pg_config —configure`
>
> If I had the sources at hand, I'd try that myself, but I don't and getting those is frankly a bit of a hassle to just test out whether that works ;)

For this issue I don't think that you are going to care much about
dependencies with low-level libraries like SSL or such as the behavior
is in integrality linked with PostgreSQL internals and the physical
representation of how transactions are handled with system catalogs. In
short there is no need to be fancy :)
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-12-27 00:48:18 Re: [table partitioning] How many partitions are possibel?
Previous Message Alban Hertroys 2017-12-26 23:27:05 Re: Deadlock between concurrent index builds on different tables