Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPBzF-0002Wn-3D for pgsql-performance@arkaria.postgresql.org; Tue, 20 Nov 2018 19:47:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gPBzD-0008S0-M1 for pgsql-performance@arkaria.postgresql.org; Tue, 20 Nov 2018 19:47:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPBzD-0008Rs-E7 for pgsql-performance@lists.postgresql.org; Tue, 20 Nov 2018 19:47:03 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gPBzA-0002xy-QC for pgsql-performance@postgresql.org; Tue, 20 Nov 2018 19:47:02 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id AE3105F79C; Tue, 20 Nov 2018 14:46:59 -0500 (EST) Date: Tue, 20 Nov 2018 14:46:59 -0500 From: Stephen Frost To: Merlin Moncure Cc: f.pardi@portavita.eu, postgres performance list Subject: Re: PostgreSQL VS MongoDB: a use case comparison Message-ID: <20181120194659.GJ3415@tamriel.snowman.net> References: <20181119172609.GR3415@tamriel.snowman.net> <20181120164325.GE3415@tamriel.snowman.net> <20181120172829.GF3415@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="CZb08McUREi1kVi+" 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 --CZb08McUREi1kVi+ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Merlin Moncure (mmoncure@gmail.com) wrote: > On Tue, Nov 20, 2018 at 11:28 AM Stephen Frost wrote: > > Oh yes, having a dictionary would be a great start to reducing the size > > of the jsonb data, though it could then become a contention point if > > there's a lot of new values being inserted and such. Naturally there > > would also be a cost to pulling that data back out as well but likely it > > would be well worth the benefit of not having to store the field names > > repeatedly. >=20 > Yes, the biggest concern with a shared dictionary ought to be > concurrency type problems. Hmmm, I wonder if we could do something like have a dictionary per page.. Or perhaps based on some hash of the toast ID.. Not sure. :) Thanks! Stephen --CZb08McUREi1kVi+ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJb9GSzAAoJEO1sijiDR2RV4J8P/2rQizqeDvabwbO2KBzCd+KZ XCaxpRtTzn6dkdt4vutDNE4LTwuTNIOJATsEC2O/vB0dmlS7nZIHZM5rOKAm2z67 nSYoE+PvMLqAKabVH16CUbHRZwfXGcW+a24eByFcWi6H3Omo0sHhaBOnh/D5aJbZ ykmuy48ucY+uCLmvLYFalHipYtLVuGZ/0SFSoHFgdVPVH4TYkAHc9RJR6b1yBpbq xBGOSg8oERCER+uUyEzQQU6WDQ66evk5v24rPskTQfU6vzhx9GSiusVLqVIWyVYp BuacfnDff0+hBsh9/4kii9RIXbHBPVexvhiYHqsabHUuTztNl84xTkKt4G7RCsxh fbOgC4w1ljUzaOAMUodjWkftkUk7xZMzaIZhC2aDcXcJlHtmquNcsHyqEe28um0I XJrY6Vf/rxbG8KrhT5Ugh8goxwZXZYR4Bsgno8w5XvbAdWLab1i1sNex5ae9ubCb scDOr5F7FozxRbULgrgW97itGZGMAlhaIxgVYRpEyV5MncnckaJkbHITFu134Oi7 RRbgoA5OMtTAp/F6dhJOl1uWqd6x8nOiHTmBjbycTgy4RikT6bYEvx1ktWLUTQGr mcHBjNZjnungBC178Iu7bVC92QqGzjkXRauU3rXBgIl31SewsMnbXDRLICTGjXSM Ey77M9cmewfvCIotvf13 =rm1p -----END PGP SIGNATURE----- --CZb08McUREi1kVi+--