Re: PostgreSQL 11 global index

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: legrand legrand <legrand_legrand(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL 11 global index
Date: 2018-08-13 22:44:49
Message-ID: FA5846F6-CF05-46E8-ACB1-72FC16CCB0BD@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Parse time & execution time.

Why are you not just using a sequence?

Do you have an application which requires contiguous numbers?

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/

> On Aug 13, 2018, at 4:39 PM, legrand legrand <legrand_legrand(at)hotmail(dot)com> wrote:
>
> I'm suspecting parsing time for "SELECT count(1) > 1 FROM tabpart WHERE id =
> NEW.id",

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2018-08-13 23:16:39 Re: PostgreSQL 11 global index
Previous Message legrand legrand 2018-08-13 22:39:44 Re: PostgreSQL 11 global index