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 1riL6v-00GfRA-If for pgsql-general@arkaria.postgresql.org; Thu, 07 Mar 2024 21:17:06 +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 1riL6t-008fjU-0p for pgsql-general@arkaria.postgresql.org; Thu, 07 Mar 2024 21:17:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1riL6s-008fjM-MG for pgsql-general@lists.postgresql.org; Thu, 07 Mar 2024 21:17:03 +0000 Received: from mail.hjp.at ([212.17.106.138] helo=rorschach.hjp.at) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1riL6n-003KA6-VJ for pgsql-general@lists.postgresql.org; Thu, 07 Mar 2024 21:17:02 +0000 Received: by rorschach.hjp.at (Postfix, from userid 1000) id C9F01D00A; Thu, 7 Mar 2024 22:16:55 +0100 (CET) Date: Thu, 7 Mar 2024 22:16:55 +0100 From: "Peter J. Holzer" To: pgsql-general@lists.postgresql.org Subject: Re: Thoughts on user-defined types for talk at Postgres conference? Message-ID: <20240307211655.mqx2pmmyflyb2jlr@hjp.at> Mail-Followup-To: pgsql-general@lists.postgresql.org References: <506dd5f4-65fe-4d34-8cfe-2ebc08b978e4@Spark> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="quyaqtlkdyipycdc" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --quyaqtlkdyipycdc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On 2024-03-06 12:45:33 -0500, Stephen Frost wrote: > =3D*# select pg_column_size(t2.*) from t2; > pg_column_size=20 > ---------------- > 53 > (1 row) >=20 > That's an additional 21 bytes, which is really quite a lot. What's > included in those 21 bytes are [...] > the type information (typmod if there is one and the OID of the > composite type), Is it necessary to store this in every row? Can a column contain different composite types? hp --=20 _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" --quyaqtlkdyipycdc Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmXqLsEACgkQ8g5IURL+ KF3W/xAAgtSjIoLy03bmU7yrOgEM/937+wzFvwUFO2f5E9p9wVqncVOJ4OheFSwt RPpZ75xo8ZULwz0GdHW7EX9mVbtqO1Il5EetiWfFP7W3dQlz+McsNH1vnEb33g3M QSKOGN5Hu8gQkYVhHAd1TfgDXoe3mnIjA5xmB5ckQDXJ9EDUYRoATpxv6UerOxOQ Oi1qlF+yPJLEjsqxuX2R/9rlNEB8VtU8T4LUg/L2kKURyZdXVNk1bRPiGVve/HoD wo/JM0Z78tGUFlroWcnM25UUEGqb8nYdgOihArjXiLSUCMTRcYvbCXPe6ltxSFux xw16vGqMYBot1uCAYA9U+4NUTMYaA2gSSh7RMFbr/dyQCgQum72137PEu8G9K/If zZrKESfRG4CIdGfmP7dLz/LzdBQdGIWgvouQarM/jDnaQCMojMZsQQchdUlVGrQk T3JTbp4suUJcUhhUWG5g6fD+/rteGCRuTCIdFQH1UWNyvARXmIs+wpFLfdQuWG2A pR9dx3rtNcv3XATwDyZlP6aP94k+j3lGX8nUQW7nAdA/z0V6TEG0hpLXJpMqYJVO LgXmES175Who4U2zc64j5hYhF+3ArDCpaYzpuCV1/nZCMDrj/gd/+OjnRjZZHlNe kbv3p8G0OL6kWSFisadhq+i0zw7z5CUCg2R+qujubtN+VKR/Z5Q= =g7nz -----END PGP SIGNATURE----- --quyaqtlkdyipycdc--