| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Arrays vs separate tables |
| Date: | 2025-10-20 14:48:10 |
| Message-ID: | D2D4C174-736D-4D1C-8A9A-9E692D8088EA@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Oct 20, 2025, at 8:42 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michał Kłeczek | 2025-10-20 14:50:01 | Re: Arrays vs separate tables |
| Previous Message | Adrian Klaver | 2025-10-20 14:42:01 | Re: Arrays vs separate tables |