Answer the question
In order to leave comments, you need to log in
What are the advantages of the JSON(b) format in PostgreSQL?
I would like to hear from PostgreSQL experts, what are the significant advantages of working with the JSON(b) format, apart from the fact that the structure of JSON(b) records can be different?
Compared to a standard table divided into fields and the same indexes .
I know that JSON does not store information about the data type, plus this is a space saving?
We take PostgreSQL version >= 9.4 for consideration
1. For example, I need to work with a log table of 1-10 billion records.
How much space does JSON(b) save compared to a regular table? (specify as a percentage)
2. Is the performance of SELECT,INSERT,UPDATE,DELETE different or not?
If yes, please describe in detail how and why.
3.What are the pros and cons of storing in JSON(b) compared to a simple table?
Answer the question
In order to leave comments, you need to log in
How much space to save
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question