Uwe Schaefer

maybe @StephanPraetsch has a more elegant idea?

```sql explain analyze select count(*) from fact where header @> '{"ns":"xyz"}' AND jsonb_path_exists(header, '$.meta.source') ``` performs comparable to ```sql explain analyze select count(*) from fact where header @> '{"ns":"xyz"}' AND...

Now, that is interesting (and a mouth full) ``` postgres=> explain analyze select count(*) from fact where header -> 'meta' -> 'source' IS NOT NULL; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------- Aggregate (cost=10000160695.49..10000160695.50...

Which leaves us with: ``` postgres=> explain analyze select count(*) from fact where header @> '{"ns":"xyz"}' AND header @? 'strict $.** ? (exists (@."meta"."source"))'; QUERY PLAN --------------------------------------------------------------------------------------------------------------------------------------------------- Aggregate (cost=155845.33..155845.34 rows=1...

Ok, we tested a lot of things and come to the conclusion: **postgres lies**. # Long story We have many ways of expressing that a json path exists. Some of...

closed with #2342

also https://dreamix.eu/blog/java/learn-from-java-champion-gunnar-morling-performance-unit-testing-with-java-flight-recorder-jfr-and-jfrunit

obsolete

Idea: factus.publishWithLock(lockTarget, attempt, andThenConsumer, config) where andThenConsumer and config are optional. config should also contain: * switch to enable exception if no publishing has happened (default=true, current behavior) * switch...

doesn't this help? https://www.baeldung.com/spring-boot-data-sql-and-schema-sql