Unverified50% confidenceFactExact time
Wrapping auth.uid() in (select ...) in a PostgreSQL policy lets Postgres evaluate it once per query rather than once per row, improving performance.
1
Sources
50%
Confidence
Long-term
Relevance
10/14/2026
First Seen
Sources
Related Entities
Related Claims
VerifiedPostgreSQL extensions are fully equal to the kernel at the query planner level, and the optimizer can perceive and utilize statistical information from extension indexes to generate execution plans.78% similarVerifiedPostgreSQL can support vector retrieval via pgvector.73% similarUnverifiedPostgreSQL treats NULL as the largest value by default, placing it at the end in ascending order and at the beginning in descending order.72% similarUnverifiedPostgreSQL subtransactions are typically created explicitly via the SAVEPOINT command, and may also be triggered implicitly by BEGIN...EXCEPTION...END exception-handling blocks in PL/pgSQL.72% similarUnverifiedPostgreSQL 的扩展系统允许用户在不修改内核的情况下添加新的数据类型、索引方法、函数和操作符70% similar
Cite This Claim
Stable URI
https://kongchang.com/claim/1028831API
curl https://kongchang.com/api/v1/knowledge/claims/1028831MCP
get_claim(id=1028831)