Re: massive update on gin index - Mailing list pgsql-general

From Rob Sargent
Subject Re: massive update on gin index
Date
Msg-id 7b4a6c68-93cc-202a-a87e-a30e6effc80f@gmail.com
Whole thread Raw
In response to Re: massive update on gin index  (Guyren Howe <guyren@gmail.com>)
Responses Re: massive update on gin index
List 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.





pgsql-general by date:

Previous
From: Guyren Howe
Date:
Subject: Re: massive update on gin index
Next
From: Marcos Pegoraro
Date:
Subject: Re: massive update on gin index