public inbox for [email protected]
help / color / mirror / Atom feedFrom: Torsten Förtsch <[email protected]>
To: anlex N <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: Is postgresql's json strong consistency or eventually consistency?
Date: Fri, 24 Jan 2025 12:07:18 +0100
Message-ID: <CAKkG4_m_O_=o8uBQu3ox-ZxF61mzHLSB+Q6GkvHfyAQyPRZmkw@mail.gmail.com> (raw)
In-Reply-To: <CAGqGHCNazFXwCo=EB2UAx5kZ771fKpYDzD41v9RPVUtb9Z3JSg@mail.gmail.com>
References: <CAGqGHCNs_OWZjhNghiaENCLdRF3g7zc4cCegRcYwB1RFLKVf8g@mail.gmail.com>
<[email protected]>
<CAGqGHCNazFXwCo=EB2UAx5kZ771fKpYDzD41v9RPVUtb9Z3JSg@mail.gmail.com>
On Fri, Jan 24, 2025 at 4:48 AM anlex N <[email protected]> wrote:
> Hello Adrian, Laurenz. Have you tried postgresql's json in your everyday
> life? How fast is it? how is it than mongodb?
>
My honest opinion, JSON(B) in PG is great as data transfer format but not
so much for storage. Here is an example. Up to last year I had a table in
my DB with rows consisting of a bunch of numbers in many columns. Over
maybe 15 years of business that table had grown to a few TB in size. Then
the development team decided they needed more flexibility and started to
fill a new table with the same information in JSON. After only 1 year of
business that table is now in the same size range.
Another example, the developers came up with a new table to store the
result of the JSON response they got from a 3rd party application. That
worked for a while and the table behaved normally. Suddenly it started
growing by a few GB a day. Turns out the 3rd party had decided to include
an MB-sized picture in the JSON response. Our team then faithfully stored
all of that crap unfiltered in the DB.
That is not an answer to your original question, of course. How fast it is
depends very much on the use case. If you are talking about access methods
alone, the ability of indexing JSON and such, then PG is on par with mongo
if not better. But nobody but you can give you a definite answer relating
to your situation.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Is postgresql's json strong consistency or eventually consistency?
In-Reply-To: <CAKkG4_m_O_=o8uBQu3ox-ZxF61mzHLSB+Q6GkvHfyAQyPRZmkw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox