差異處
這裏顯示兩個版本的差異處。
Both sides previous revision 前次修改 下次修改 | 前次修改 下次修改 Both sides next revision | ||
database:postgres [2019/08/12 00:54] tony [Resource] |
database:postgres [2020/04/18 00:29] tony [Resource] |
||
---|---|---|---|
行 11: | 行 11: | ||
* [[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://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://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?]] | ||