Lemmy PostgreSQL

33 readers

2 users here now

founded 1 year ago

MODERATORS

[email protected]

PostgreSQL usage in Lemmy is many JOIN (bulletintree.com)

submitted 1 year ago by [email protected] to c/[email protected]

10 comments fedilink hide all child comments

Some learning about JOIN filled queries like the SELECT that is used to list post_aggregates table when browsing postings on Lemmy.

https://dba.stackexchange.com/questions/155972/postgres-join-conditions-vs-where-conditions

"Logically, it makes no difference at all whether you place conditions in the join clause of an INNER JOIN or the WHERE clause of the same SELECT. The effect is the same. (Not the case for OUTER JOIN!)"

Learning about join_collapse_limit

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 1 points 1 year ago

The order of JOIN matters, and I don't think Lemmy's Rust code evolved at all with that in mind...

https://stackoverflow.com/questions/73687036/extremely-slow-planning-for-query-with-lot-of-joins-in-postgresql