Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vArBT-006dH5-Vk for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 14:48:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vArBS-001dAa-Kd for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 14:48:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vArBS-001dAG-6o for pgsql-general@lists.postgresql.org; Mon, 20 Oct 2025 14:48:25 +0000 Received: from mail-pg1-x52a.google.com ([2607:f8b0:4864:20::52a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vArBP-002o5q-14 for pgsql-general@lists.postgresql.org; Mon, 20 Oct 2025 14:48:24 +0000 Received: by mail-pg1-x52a.google.com with SMTP id 41be03b00d2f7-b6093f8f71dso3008872a12.3 for ; Mon, 20 Oct 2025 07:48:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760971702; x=1761576502; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=43MxnnjdPI0Oz2jm3oQyEbfsgOCXyWLAsUKOBLPV5Dc=; b=ioNM2uPJtnvemNb9RbJ8f9fI4o1yRVAqBxFz1l+5KYkXQ3mc9Gl5pm9wDmAdfsXQ1o oa1fBX69m65qLhYPme1rNpeU14dagKfr/Yq2VkmURRyb5WJ0oea6V1a+nQQGdYp5inVs PGIVYXu+ExkrgfVJrAfsdeXZkYBVZd2c7OofIfynkLfWa0q3srSDDM1s7ZORTMHCq8lT h8UpXu5WEQUT+i1rCGF0SLCziiOlI3Vt0H0ElKUTUp9HzcDdE11yzfCsXzI8pbrappXv tJnd57GU+/edhTdovhNLFuohH9VGCXHyTOf9JhPsxr8x2aA+IQkk4NM/jr3kDT7w4SeG /rXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760971702; x=1761576502; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=43MxnnjdPI0Oz2jm3oQyEbfsgOCXyWLAsUKOBLPV5Dc=; b=rQmJa64vKy1v9JM3ZMPPBzWPqq8qMxEKU+54iTUbubM2/krXNwdD8N4RJqHFpbqOmj +pBXv6foLgZ0D1QQiHrsP+FNElWAyhJ6eJqUSRrqhhSeMSEZd+Kz6YzMGaQRUblgeaRx wc8IuD14yNK5uWhKRTKpYVDEay6m/7aPG5klQW4X5SO4fO1a8ZNGmhcNaYC+mqe7bp8r Ou6jyLIzHrHiJujnT92kcFv6XH4uyGegOtHwZdTq14z6fTqnjDf/LDkGA/S1YgykfQN2 vqqr1pUcemNxO15BeRnqYzv+CUcyitEZJll0N9rc/25iamtOrX21UMEt3ES4byap9HsM mRcQ== X-Forwarded-Encrypted: i=1; AJvYcCUOvHMx4xn4orTQEdfWsRUrvf365qTsBkuCfW32JhpMaLlKvs5Cq4iUNjn/ggTvk5v20OKCik9drq+xZX9x@lists.postgresql.org X-Gm-Message-State: AOJu0YxDp1TFaocoiQK3z8ZCWiTaRseT+c3QHGMqnrOwR1ZTyHriS1Nz iCZOeh0DZxrhQ5OUrfFzJeNZ0JpSh1CFL1ldil1X8WabLg1uIsg5wWqzqbuWX53B X-Gm-Gg: ASbGncszknh3UrEznRgKA9ipq7CLVLyHVmt6+lWxOQZhyRvrDmVQZiWVfQrPR8sbX+v VrapQbgU1cRi9Uo6qG2ysAuSE7nQ0kHPOj7dOLa3lFJT6m4Rhu8ey56Tms0tmebwVNyd0WDMOCv zcFpYTaChBIHd/1duiGlcCznFpB2Wd7/cDwLAspuHxxliE96rY1Qb7G31WH/5EDMKcXJkRdrNN1 pVTOgiZlu9Bc+fTZyGClbfUTQnBMHsCFVJ/mRSMxxesBYe/BqSl6k4v4W099Qe2AgtamvEFoZoJ 8ibdKTZSj4LE+1fGLBn3GuW6JgY8g9tDVoEXGYpZhdG6LlCFTV1jiGELR6Z59iJ2nmD9xUijVa7 gvr0lnmOmSTth16dUDBa8JHsjDy2NAh6KHTt5a2oEHI2Pm5KjfECZLreI6/+nlqwAEQoI7d+El4 7avtAhbUoZwvbbIAZ7xgFjjZwBgS2rL0NK X-Google-Smtp-Source: AGHT+IFogRG2ABTUGdKicFBk4fi7PUaiBR5sdB0I2R94FFttlJCJVi1nMOpbQbe8K4KttCr8oLzJbQ== X-Received: by 2002:a17:903:138a:b0:25e:5d83:2ddd with SMTP id d9443c01a7336-290cc6d4512mr133200035ad.45.1760971702059; Mon, 20 Oct 2025 07:48:22 -0700 (PDT) Received: from smtpclient.apple ([15.220.16.55]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-292c6cc17ecsm5141975ad.48.2025.10.20.07.48.21 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 20 Oct 2025 07:48:21 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Arrays vs separate tables Date: Mon, 20 Oct 2025 08:48:10 -0600 Message-Id: References: Cc: Rich Shepard , pgsql-general@lists.postgresql.org In-Reply-To: To: Adrian Klaver X-Mailer: iPhone Mail (22G100) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Oct 20, 2025, at 8:42=E2=80=AFAM, Adrian Klaver wrote: >=20 > =EF=BB=BFOn 10/20/25 07:07, Rich Shepard wrote: >>> On Mon, 20 Oct 2025, Micha=C5=82 K=C5=82eczek wrote: >>> There is also another concern - do you want to make sure phone numbers a= re >>> not shared? >> Michal, >> Shared with whom? I run a solo professional services consultancy so there= 's >> only me here the database. >=20 > 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 chan= ge things. Given the size of your datasets I don't see that changes will mat= erially 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.=20=