Re: massive update on gin index

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: massive update on gin index
Date: 2022-09-14 19:46:52
Message-ID: 7b4a6c68-93cc-202a-a87e-a30e6effc80f@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/14/22 13:38, Guyren Howe wrote:
> You might consider defining a phone type that includes your “type”
> information, and just having an array of those, if you really want to
> do something like this.
>
> But a related table instead would be the obvious answer.

Did you try a simple array of phone numbers?  If you really care about
mobile,work,home prepend the number with one of HMW. Easily stripped off
as necessary.  I've had decent performance with arrays in the past.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcos Pegoraro 2022-09-14 19:51:29 Re: massive update on gin index
Previous Message Guyren Howe 2022-09-14 19:38:17 Re: massive update on gin index