Re: Is there a work around for partition key needed for constraint

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Is there a work around for partition key needed for constraint
Date: 2018-10-25 21:36:02
Message-ID: 1540503362863-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jehan-Guillaume (ioguix) de Rorthais wrote
> On Thu, 25 Oct 2018 14:02:46 -0700 (MST)
>
> It seems to me you lack some locking to avoid duplicates. cf. my blog post
> we
> discussed few weeks ago.
>
> (btw, sorry, I somehow missed your answers on previous thread b/c
> holidays).

Yes you are right, I forgot to speak about locking, and performance
degradation
with the number of partitions ... as discussed in the previous thread ;o)

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Torralba 2018-10-25 22:54:19 Re: Is there a work around for partition key needed for constraint
Previous Message Jehan-Guillaume (ioguix) de Rorthais 2018-10-25 21:16:55 Re: Is there a work around for partition key needed for constraint