I also started playing with 3.5 Flash and was impressed.
It’s 2× faster than its competitors. For tasks where “one-shotting” is unrealistic, a fast iteration loop makes a measurable difference in productivity.
That nested JSON query operator chains such as json_col->'foo'->'bar'->>'baz' internally return (copy) entire sub-objects at each level and can be much slower than jsonb_path_query(json_col, '$.foo.bar.baz') for large JSONB data
... although I haven't had the chance to verify this myself
I got nerd-sniped on this, because I actually hadn't heard that before and would be horrified if it were true. It took some non-trivial digging to even get down into the "well, what does foo->>'bar' even map to in C?" level. I for sure am not claiming certainty, but based merely on "getIthJsonbValueFromContainer"
<https://sourcegraph.com/github.com/postgres/postgres@REL_17_...> it does seem that they do palloc copies for at least some of the JSONB calls
Postgres does have infrastructure to avoid this in cases where the result is reused, and that's used in other places, e.g. array constructors / accessors. But not for jsonb at the moment.
Made in China products by Japanese ventures is fine, just like iPhone made in China. We know China is great at cost effective manufacturing. It's annoying that some "ventures" just rebadging existing Chinese products with Japan flag and minor improvement. Recently I tend to find such products in mobility area like this.
Rebadging is exactly what it is when you talk about made by japanese ventures. Nothing is made in japan anymore, however it s a secret noone is allowed to talk about.
You may be surprised how much of it is made not in Japan.
Thought we are grown up snd don’t understand things literally. Of course there are lots of things made in japan, but the point is, it’s way past its manufacturing times。
Manufactured in China is not a problem for non manufacturing oriented ventures, as I said it's like Apple. Though for EV, non manufacturing oriented EV car venture could be a nonsense.
It's a Chinese name. Specifically a name romanized using a system typically used in Taiwan, I think (you tend to see "hs" in Taiwanese names whereas in the PRC "Hsiao" would be "Xiao"). Taiwan has close ties to Japan so that's not too surprising really.
It’s 2× faster than its competitors. For tasks where “one-shotting” is unrealistic, a fast iteration loop makes a measurable difference in productivity.