差異處

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

連向這個比對檢視

Both sides previous revision 前次修改
下次修改
前次修改
database:postgres [2020/12/06 00:40]
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]]
行 18: 行 19:
   * [[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://​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://​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]]