Feedback-ID: i76984098:Fastmail
Message-ID: <caa70601-f6ee-4dd7-9259-7ab9ecc5497b@aklaver.com>
Date: Mon, 20 Oct 2025 07:42:01 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Arrays vs separate tables
To: Rich Shepard <rshepard@appl-ecosys.com>,
 pgsql-general@lists.postgresql.org
References: <162e5330-861c-ecc7-45c1-aaa1aff26c88@appl-ecosys.com>
 <pyh2kcisxwrhzz255gaiaawo5yubirdifzsfvz3okqcjeaaqqr@6lq5n6idswg7>
 <95de5a9b-4dd8-2f7-6e12-98c3d72c52@appl-ecosys.com>
 <CC75487C-BBDF-474D-880A-87FB6CEED812@kleczek.org>
 <712b8b5c-15d2-e284-a0c0-6263415250c3@appl-ecosys.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <712b8b5c-15d2-e284-a0c0-6263415250c3@appl-ecosys.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/caa70601-f6ee-4dd7-9259-7ab9ecc5497b%40aklaver.com>
Precedence: bulk

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