public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rob Sargent <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: Rich Shepard <[email protected]>
Cc: [email protected]
Subject: Re: Arrays vs separate tables
Date: Mon, 20 Oct 2025 08:48:10 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>



> On Oct 20, 2025, at 8:42 AM, Adrian Klaver <[email protected]> wrote:
> 
> 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.

And all the hot tables have been paged in if not the entire db. 

view thread (8+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Arrays vs separate tables
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox