Rendered at 13:37:48 GMT+0000 (Coordinated Universal Time) with Cloudflare Workers.
nasretdinov 6 hours ago [-]
As someone who tried doing things like condition pushdown, transpiling from one language to another, etc, this is really impressive. Correctly pushing subqueries while preserving the semantics of the original database is something I can't imagine I could've ever achieved
manjose2018 13 hours ago [-]
Please consider comparing pg_clickhouse to pgrust.
They're not really compatable. Your link already compares pgrust & clickhouse. A comparison would not be by using postgres_fdw from postgres to pgrust
rluisr 15 hours ago [-]
[flagged]
manbash 13 hours ago [-]
> December's headline feature was teaching the planner to push a whole correlated EXISTS subquery down as a single LEFT SEMI JOIN instead of a nested loop with one ClickHouse round trip per outer row. This moved the needle from 3 of 22 TPC-H queries all the way to 12.
LLMs sure love throwing in archaic expressions such as "move the needle". The abrupt contrast in jargons is so unpleasant and keeps throwing me off right in the middle of reading.
hi_hi 8 hours ago [-]
LLMs have provided the uncanny valley to writing.
eskaytwo 3 hours ago [-]
Yeah. There's some solid work in there, but it reads like an LLM without a review pass.
This paragraph has an awkward rhythm:
> Getting more into the nitty-gritty, we also closed a subsecond-precision loss when inserting timestamps over HTTP (#300), and to top it all off, a broader static-analysis pass over the codebase turned up and fixed a handful of other latent bugs (#313); these hadn't showed up in the field, but were worth closing before they could.
Even just asking Claude to apply Strunk and White makes it much easier to read:
> We also fixed a loss of subsecond precision in timestamps inserted over HTTP (#300). A static-analysis pass over the codebase turned up several other latent bugs (#313); none had surfaced in the field, but we fixed them anyway.
And its diagnosis of why the original is tricky shows an LLM is more than capable of improving readability given a couple of review passes:
> Three things make it awkward, and they pile up:
> 1. Two bits of throat-clearing. "Getting more into the nitty-gritty" and "to top it all off" both just say here comes the next thing. Neither tells you anything. Back to back, they read as filler.
> 2. Mixed tone. "Nitty-gritty" and "to top it all off" are chatty; "subsecond-precision loss" and "static-analysis pass" are dry and technical. The sentence keeps switching voice.
> 3. Too much in one sentence. Two unrelated fixes joined by a semicolon, plus a clause hanging off the second one, plus the trailing "before they could." By the end, you've lost track of what "they could" was about — the thing it points back to is thirty words behind you.
It's a shame when solid technical work gets obscured by the poor SNR of default LLM output, when clarity is only a few iterations away.
https://malisper.me/how-we-made-postgres-hundreds-of-times-f...
LLMs sure love throwing in archaic expressions such as "move the needle". The abrupt contrast in jargons is so unpleasant and keeps throwing me off right in the middle of reading.
This paragraph has an awkward rhythm:
> Getting more into the nitty-gritty, we also closed a subsecond-precision loss when inserting timestamps over HTTP (#300), and to top it all off, a broader static-analysis pass over the codebase turned up and fixed a handful of other latent bugs (#313); these hadn't showed up in the field, but were worth closing before they could.
Even just asking Claude to apply Strunk and White makes it much easier to read:
> We also fixed a loss of subsecond precision in timestamps inserted over HTTP (#300). A static-analysis pass over the codebase turned up several other latent bugs (#313); none had surfaced in the field, but we fixed them anyway.
And its diagnosis of why the original is tricky shows an LLM is more than capable of improving readability given a couple of review passes:
> Three things make it awkward, and they pile up:
> 1. Two bits of throat-clearing. "Getting more into the nitty-gritty" and "to top it all off" both just say here comes the next thing. Neither tells you anything. Back to back, they read as filler.
> 2. Mixed tone. "Nitty-gritty" and "to top it all off" are chatty; "subsecond-precision loss" and "static-analysis pass" are dry and technical. The sentence keeps switching voice.
> 3. Too much in one sentence. Two unrelated fixes joined by a semicolon, plus a clause hanging off the second one, plus the trailing "before they could." By the end, you've lost track of what "they could" was about — the thing it points back to is thirty words behind you.
It's a shame when solid technical work gets obscured by the poor SNR of default LLM output, when clarity is only a few iterations away.