Re: Arrays vs separate tables - Mailing list pgsql-general

From Rich Shepard
Subject Re: Arrays vs separate tables
Date
Msg-id 16c131f2-122e-2b9-6478-55b418201255@appl-ecosys.com
Whole thread Raw
In response to Re: Arrays vs separate tables  (Ray O'Donnell <ray@rodonnell.ie>)
List 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 by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Arrays vs separate tables
Next
From: Rob Sargent
Date:
Subject: Re: Convert date and time colums to datetime