Postgresql easy
When storing document-based data in PostgreSQL, why is the `jsonb` type typically preferred over the legacy `json` type for production workloads?
- A It preserves the exact white-space of the raw input to ensure a perfect character-level audit log.
- B It utilizes a decomposed binary format that supports indexing and allows for faster object processing.
- C It compresses the JSON strings using GZIP to minimize the physical disk footprint of large documents.
- D It automatically converts all numeric values to high-precision floats to prevent rounding errors.
Answer: B. It utilizes a decomposed binary format that supports indexing and allows for faster object processing.
`json` is a plain text copy, while `jsonb` (Binary JSON) is pre-parsed. This allows for GIN indexing and faster access as the database doesn't need to re-parse the string for every query.
One system design question a day, with spaced repetition so the ones you miss come back.
Get the appRelated questions
- In a PostgreSQL environment, what functional characteristic distinguishes a `MATERIALIZED VIEW` from a standard `VIEW`?
- Which standard PostgreSQL utility is designed to extract a single database into a script or archive file for backup purposes?
- Why would PostgreSQL reject a `DELETE` operation on a record despite the user having full administrative privileges?
- The 'Heap Only Tuples' (HOT) optimization improves UPDATE performance. Which specific set of conditions must be met for a HOT update to occur?
- Which native command-line utility is used to execute SQL queries and manage PostgreSQL databases from a terminal session?
- What is the specific purpose of 'Freezing' a row (modifying its `xmin` status) during a major VACUUM operation?