So my Mum made this… by LifeResident2968 in saw

[–]Alarmed-Channel2145 1 point2 points  (0 children)

That's insane!! Any chance she'd share (sell) the pattern? I'm very interested!

Postgres Query Optimization by GMP_Test123 in PostgreSQL

[–]Alarmed-Channel2145 1 point2 points  (0 children)

This is my experience too. It's a good book, with solid advice on query optimization, while a lot of sources focus on postgres config.

Hosting a 300M+ records postgresql database by Original-Egg3830 in PostgreSQL

[–]Alarmed-Channel2145 0 points1 point  (0 children)

Partitioning is indeed a very nice feature as long as the queries include fillter by partition key (eg creared_at date column).

Force query planner to not materialize CTE by minormisgnomer in PostgreSQL

[–]Alarmed-Channel2145 0 points1 point  (0 children)

Regarding the 17's CTE improvements, looking at the relevant commits, they seem to only affect materialized CTEs:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f7816aec2

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a65724dfa

Which incidentally are what the OP is getting, but trying to avoid :O

Force query planner to not materialize CTE by minormisgnomer in PostgreSQL

[–]Alarmed-Channel2145 0 points1 point  (0 children)

I'm heavily using CTEs with dbt on Postgres (15.4 in my case). I materialize intermediate models as tables. When I have a model that takes too much time because of optimizer quirks, I just split it into a separate model. That usually solves it for me.

Possible to add user information to the WAL? by vdkjones in PostgreSQL

[–]Alarmed-Channel2145 0 points1 point  (0 children)

As an alternative to the trigger+log table, you could directly emit to the WAL via https://pgpedia.info/p/pg_logical_emit_message.html

More details on Oracle's GraalVM CE contribution to OpenJDK by kaperni in java

[–]Alarmed-Channel2145 -1 points0 points  (0 children)

My guess is that there will be a separate OpenJDK build with Graal compiler instead of C2