Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k19YK-0001oL-Te for pgsql-novice@arkaria.postgresql.org; Thu, 30 Jul 2020 14:29:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k19YJ-00007M-Ny for pgsql-novice@arkaria.postgresql.org; Thu, 30 Jul 2020 14:28:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k19YJ-00007E-Hq for pgsql-novice@lists.postgresql.org; Thu, 30 Jul 2020 14:28:59 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k19YD-0007uj-FM for pgsql-novice@lists.postgresql.org; Thu, 30 Jul 2020 14:28:58 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 007DC5F79F; Thu, 30 Jul 2020 10:28:52 -0400 (EDT) Date: Thu, 30 Jul 2020 10:28:52 -0400 From: Stephen Frost To: Chamath Sajeewa Cc: David Raymond , pgsql-novice@lists.postgresql.org Subject: Re: PGSQL insert data to a oid column using SOCI Message-ID: <20200730142852.GW12375@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Q/EcqcSgguwIrH84" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Q/EcqcSgguwIrH84 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, * Chamath Sajeewa (csgsajeewa@gmail.com) wrote: > What is the correct data type to be used for large objects then? I'd suggest you seriously consider if you can just use a 'bytea' for the object rather than the actual large object system. 'bytea' is limited to 1GB, though you could chunk up larger objects if needed. Thanks, Stephen --Q/EcqcSgguwIrH84 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJfItkkAAoJEO1sijiDR2RV14IP/1v8iJoZbBKYd2pF/dULb5Wq 6HRp0xPCiJK0pv/yQ5XgX5bjl77PF9KyfjqwhrfCIpxAM8LYnidnSCLcKlmkvqOU mxgqw1/A5mz9j0Ws8p9xfc2MyauC32KE+3c35UwiNYytH/PJgCBKU/RYhlcsuuly Y6G9XDM4+UJ+4githITN5ShQb2PtioklaKeXJ87U2UuLvUOUYJga1jveTWzcPxor TVO6EdFUKLPsfe/69O5hNJDcAcxJjiv5pE7TfxAtBGvXlJx/ied6SdL24FYf0Aq0 v0vClM7CmLkb7SwLnI7emiYz2qNJIWXHl12a/1ZTqthCWM+qck94irbtFwnbS5AS fNhbE+Lz31EqaKR/zUweS0JgCmKg0lu4oXfRtOueqJR+HEBfgiwXzFrETOHWtSgJ MYrGORLk9s+L/z/38KoVxTdF6Uk9yzet8rzThgoJ1Dk+TgtGsKgrEZqrV8VL5RH2 0TZfeZ8qxypg9DYhtgJdp7Ri0gnsyBJ9L7pmUEDYgHLb0Zry85fNHl54ZycCyBIB DYqO5K4eKiUUdSQzkDjOi/GOkT5uyds2PZx43SU8pW1ZW6Zq8fXZ7wtN16gjUu32 1vt5PvGuHZT5v7Nq1NJ88iUi2kkzMDjN6Q1MEHqsUuEuRR7IRlp9R9vNmjGlzOog 8ZiDxwcrizAbQio2Imm5 =mxAr -----END PGP SIGNATURE----- --Q/EcqcSgguwIrH84--