差異處
這裏顯示兩個版本的差異處。
Both sides previous revision 前次修改 下次修改 | 前次修改 | ||
database:postgres [2019/08/22 22:42] tony [Resource] |
database:postgres [2022/09/07 22:25] tony [Articles] |
||
---|---|---|---|
行 5: | 行 5: | ||
===== Articles ===== | ===== Articles ===== | ||
* [[database:postgres:unattended_installation_on_windows|Unattended installation on windows]] | * [[database:postgres:unattended_installation_on_windows|Unattended installation on windows]] | ||
+ | * [[database:postgres:alignment|Data Alignment in PostgreSQL]] | ||
===== Resource ===== | ===== Resource ===== | ||
* [[https://zh.wikipedia.org/zh-tw/PostgreSQL|wiki]] | * [[https://zh.wikipedia.org/zh-tw/PostgreSQL|wiki]] | ||
行 13: | 行 14: | ||
* [[https://juejin.im/post/5d552066518825056144e7ba|[译] 使用 PostgreSQL 的一些建议]] | * [[https://juejin.im/post/5d552066518825056144e7ba|[译] 使用 PostgreSQL 的一些建议]] | ||
* [[https://blog.csdn.net/EthanWhite/article/details/56483370|Materialized View模式]] | * [[https://blog.csdn.net/EthanWhite/article/details/56483370|Materialized View模式]] | ||
+ | * [[https://dba.stackexchange.com/questions/91247/optimizing-a-postgres-query-with-a-large-in|Optimizing a Postgres query with a large IN]] | ||
+ | * [[https://www.postgresql.org/message-id/Pine.LNX.4.64.0702251740260.400%40sn.sai.msu.ru|Very large IN-clause is slow, but how to rewrite it?]] | ||
+ | * [[https://postgres.cz/wiki/PostgreSQL_SQL_Tricks_I#Predicate_IN_optimalization|Predicate IN optimalization]] | ||
+ | * [[https://www.citusdata.com/blog/2018/02/22/seven-tips-for-dealing-with-postgres-locks/|When Postgres blocks: 7 tips for dealing with locks]] | ||
+ | * [[https://shusson.info/post/dealing-with-deadlocks-in-postgres|Dealing with deadlocks in postgres]] | ||
+ | * [[https://github.com/digoal/blog?fbclid=IwAR2lc2DldAni4E47JHk9jLt9HkXEl20dHCzZkxPkMWyIv_LFaYzyjHPDqbc|digoal blog]] | ||
+ | * [[https://dba.stackexchange.com/questions/111187/postgresql-size-of-temporary-files|PostgreSQL “size of temporary files”]] | ||
+ | * [[https://www.postgresql.org/docs/current/app-initdb.html|initdb linux只允許non-root]] | ||
+ | * [[https://www.postgresql.org/message-id/1293141830332-3317041.post@n5.nabble.com|"root" execution not permitted. and busybox]] | ||
+ | * [[https://docs.postgresql.tw/appendixes/additional-supplied-modules/auto_explain|auto-explain]] | ||