Re: massive update on gin index

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: massive update on gin index
Дата
Msg-id 7b4a6c68-93cc-202a-a87e-a30e6effc80f@gmail.com
обсуждение исходный текст
Ответ на Re: massive update on gin index  (Guyren Howe <guyren@gmail.com>)
Ответы Re: massive update on gin index  (Marcos Pegoraro <marcos@f10.com.br>)
Список 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 по дате отправления:

Предыдущее
От: Guyren Howe
Дата:
Сообщение: Re: massive update on gin index
Следующее
От: Marcos Pegoraro
Дата:
Сообщение: Re: massive update on gin index