Post #3585053
2026-06-30 22:14 UTC
@jacques@mastodon.chester.id.au That's not far from what I'm dealing with. It's SQL view, transformed into a CTE (literally, the view definition is queried and then prepended into a `WITH` clause) so Postgres will materialize it at query time.
Replies (1)
-
@jamie@zomglol.wtf 2026-06-30 22:15
@jacques@mastodon.chester.id.au It's faster than what it used to be before someone added that transformation. The CTO got clever several years ago and implemented a lot of things in terms of views as a query abstraction. Turned out to be a bottleneck with scale, and now it's load-bearing.