Exploring postgres custom data types
This repository compares JSONB and User Defined Type in Postgres to understand and find out:
- Common operators of JSONB.
- Use-cases when JSONB operators make use of an index and when they do not.
- Which one is easier for querying and indexing.
- Indexing on column of User Defined Type using default operator classes of postgres.
The repo is specific for Postgres with pgjdbc-ng driver, norm and code examples are in Kotlin.