差異處

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

連向這個比對檢視

下次修改
前次修改
database:postgres [2019/04/20 18:25]
tony 建立
database:postgres [2022/09/07 22:25] (目前版本)
tony [Articles]
行 3: 行 3:
 ===== Introduction ===== ===== Introduction =====
 PostgreSQL是BSD license的open source關聯式資料庫,會接觸到它是因為工作的關係。本區會分享紀錄有使用到的技術與遇到的問題。 PostgreSQL是BSD license的open source關聯式資料庫,會接觸到它是因為工作的關係。本區會分享紀錄有使用到的技術與遇到的問題。
 +===== Articles =====
 +  * [[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]]
   * [[https://​www.enterprisedb.com/​resources/​edb-product-documentation/​installation-guide-edb-postgres-advanced-server-10|Installation Guide for PostgreSQL 10]]   * [[https://​www.enterprisedb.com/​resources/​edb-product-documentation/​installation-guide-edb-postgres-advanced-server-10|Installation Guide for PostgreSQL 10]]
 +  * [[https://​github.com/​digoal/​blog/​blob/​master/​201808/​20180823_01.md|修改postgresql設定 for test]]
 +  * [[https://​www.slideshare.net/​RubyMeditation/​postgres-vs-elasticsearch-while-enriching-data-vlad-somov-ruby-meditaiton-23|Postgres vs Elasticsearch while enriching data - Vlad Somov | Ruby Meditaiton #23]]
 +  * [[https://​medium.com/​d-d-mag/​postgresql-%E7%95%B6%E4%B8%AD%E7%9A%84-index-e7e1e8d9340c|PostgreSQL 筆記 — 索引]]
 +  * [[https://​juejin.im/​post/​5d552066518825056144e7ba|[译] 使用 PostgreSQL 的一些建议]]
 +  * [[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]]