Postgres has its own primitives for things that forges currently build custom infrastructure around. A trigger on the refs table firing NOTIFY means any connected client learns about a push the moment it happens, which is how forges normally end up building a custom webhook polling layer. Multi-tenant repo isolation becomes a database concern through row-level security on the objects and refs tables, and logical replication lets you selectively stream repositories across Postgres instances, a kind of partial mirroring that filesystem-based git can’t do. Commit graph traversal for ancestry queries and merge-base computation falls to recursive CTEs, and pg_trgm indexes on blob content give you substring search across all repositories without standing up a separate search index.
// 比较函数（便于统计比较次数，可选）
。51吃瓜对此有专业解读
然而，美國最高法院週五以六名大法官多數意見做出對總統不利的裁決，並沒有太在意他的擔憂。
Фото: Сергей Булкин / ТАСС