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

From Adrian Klaver
Subject Re: Arrays vs separate tables
Date
Msg-id caa70601-f6ee-4dd7-9259-7ab9ecc5497b@aklaver.com
Whole thread Raw
In response to Re: Arrays vs separate tables  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Arrays vs separate tables
List pgsql-general
On 10/20/25 07:07, Rich Shepard wrote:
> On Mon, 20 Oct 2025, Michał Kłeczek wrote:
> 
>> There is also another concern - do you want to make sure phone numbers 
>> are
>> not shared?
> 
> Michal,
> 
> Shared with whom? I run a solo professional services consultancy so there's
> only me here the database.

That is the heart of the matter, you should do what makes sense to you. 
If you can get the information you need in the manner you want then 
don't change things. Given the size of your datasets I don't see that 
changes will materially affect the performance of your queries. I am 
pretty sure most of the time the Postgres planner is resorting to a 
sequence scan anyway.

> 
> Rich
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Arrays vs separate tables
Next
From: Rob Sargent
Date:
Subject: Re: Arrays vs separate tables