Re: Arrays vs separate tables

Rich Shepard <rshepard@appl-ecosys.com>

From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Date: 2025-10-19T21:49:01Z
Lists: 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