PostgreSQL

PostgreSQL是BSD license的open source關聯式資料庫，會接觸到它是因為工作的關係。本區會分享紀錄有使用到的技術與遇到的問題。

• Unattended installation on windows
• Data Alignment in PostgreSQL

• wiki
• Installation Guide for PostgreSQL 10
• 修改postgresql設定 for test
• Postgres vs Elasticsearch while enriching data - Vlad Somov | Ruby Meditaiton #23
• PostgreSQL 筆記 — 索引
• [译] 使用 PostgreSQL 的一些建议
• Materialized View模式
• Optimizing a Postgres query with a large IN
• Very large IN-clause is slow, but how to rewrite it?
• Predicate IN optimalization
• When Postgres blocks: 7 tips for dealing with locks
• Dealing with deadlocks in postgres
• digoal blog
• PostgreSQL “size of temporary files”
• initdb linux只允許non-root
• "root" execution not permitted. and busybox
• auto-explain