Re: Arrays vs separate tables

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Arrays vs separate tables
Дата
Msg-id 16c131f2-122e-2b9-6478-55b418201255@appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Arrays vs separate tables  (Ray O'Donnell <ray@rodonnell.ie>)
Список pgsql-general
On Sun, 19 Oct 2025, Ray O'Donnell wrote:

> My experience of doing something similar was that arrays work very well
> for the use-case you describe, as long as you don't have to search inside
> the arrays... I found that, if you have to search for a specific value
> inside an array, then performance really goes out the window. Mind you,
> clever use of an index would probably help here.

Ray,

So far searching has not been an issue so I'll keep the status quo.

Thanks,

Rich



В списке pgsql-general по дате отправления: