差異處

這裏顯示兩個版本的差異處。

連向這個比對檢視

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]]