差異處

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

連向這個比對檢視

Both sides previous revision 前次修改
下次修改
前次修改
database:postgres [2020/04/18 00:29]
tony [Resource]
database:postgres [2023/06/25 09:48] (目前版本)
行 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]]
行 15: 行 16:
   * [[https://​dba.stackexchange.com/​questions/​91247/​optimizing-a-postgres-query-with-a-large-in|Optimizing a Postgres query with a large IN]]   * [[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://​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]]