[Postgres-xl-developers] UNIQUE constraint

Paulo henrique França Silva phmasters at hotmail.com
Fri May 19 11:30:13 PDT 2017


Hi Simon,


But If it store only the constraints keys? Do the check constraint and pass the rest to datanodes. We could still be benefit from  parallelism and scale.


Regards
Paulo H


________________________________
De: Simon Riggs <simon at 2ndquadrant.com>
Enviado: sexta-feira, 19 de maio de 2017 18:20
Para: Paulo henrique França Silva
Cc: postgres-xl-developers at lists.sourceforge.net
Assunto: Re: [Postgres-xl-developers] UNIQUE constraint

On 19 May 2017 at 18:43, Paulo henrique França Silva
<phmasters at hotmail.com> wrote:

>  Thank you very much for your response.

> One question, and if we store the key data in coordinator? So we wouldn't
> need to do  round-trips? If you think that it is possible, I could make a
> patch. I'm studying the code and willing to help.

I'm not sure that would help. If the coordinator could store all the
data we wouldn't need XL, you'd just use single node Postgres.

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20170519/15dafd1d/attachment.htm>


More information about the Postgres-xl-developers mailing list