Re: Arrays vs separate tables

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Arrays vs separate tables
Date: 2025-10-19 21:49:01
Message-ID: 16c131f2-122e-2b9-6478-55b418201255@appl-ecosys.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2025-10-20 02:32:07 Re: Convert date and time colums to datetime
Previous Message Rich Shepard 2025-10-19 21:44:19 Re: Arrays vs separate tables