PostgreSQL

https://www.slideshare.net/MarkusWinand/standard-sql-features-where-postgresql-beats-its-competitors

https://news.ycombinator.com/item?id=15859849

https://habrahabr.ru/company/oleg-bunin/blog/319018/

https://habrahabr.ru/company/postgrespro/blog/326106/ Indexy v Pg

http://www.craigkerstiens.com/2018/01/31/postgres-hidden-gems/

http://www.postgresonline.com/journal/archives/173-Using-LTree-to-Represent-and-Query-Hierarchy-and-Tree-Structures.html

http://www.craigkerstiens.com/2017/04/30/why-postgres-five-years-later/

http://www.sai.msu.su/~megera/postgres/talks/jsonb-stachka-2017-full.pdf

http://www.interdb.jp/pg/index.html

http://obartunov.livejournal.com/195274.html

http://rhaas.blogspot.com/2017/04/new-features-coming-in-postgresql-10.html

http://yogthos.net/posts/2016-11-05-LuminusPostgresNotifications.html

http://postgresapp.com/ for Mac

http://postgresql.leopard.in.ua/ book

https://www.justwatch.com/blog/post/debugging-postgresql-performance-the-hard-way/

https://www.pgcon.org/2016/schedule/attachments/

http://postgrest.com/ - REST API web server for postgres

http://renesd.blogspot.com/2017/02/is-postgresql-good-enough.html

https://news.ycombinator.com/item?id=13641377

https://www.youtube.com/watch?v=n5yt67uZdgQ Replication

https://habrahabr.ru/post/308752/

https://habrahabr.ru/post/311586/

http://blog.ryankelly.us/2016/08/21/postgres-the-good-parts-arrays.html

https://tech.lendinghome.com/practical-guide-to-postgresql-optimizations-d7b9c2ad6a22#.5y1w05e95

https://news.ycombinator.com/item?id=12352831

UI client

https://habrahabr.ru/company/pgdayrussia/blog/325642/

https://github.com/sosedoff/pgweb

https://eggerapps.at/postico/

http://www.psequel.com/

https://begriffs.com/posts/2016-03-20-postgrest-tour.html

https://habrahabr.ru/company/postgrespro/blog/307612/

http://bonesmoses.org/2016/07/15/pg-phriday-a-postgres-persepctive-on-mongodb/

https://pgexercises.com/

http://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/ lateral join

https://robots.thoughtbot.com/postgres-index-types

https://robots.thoughtbot.com/advanced-postgres-performance-tips

https://www.pgcasts.com/

https://habrahabr.ru/post/282764/

https://habrahabr.ru/post/302768/

https://habrahabr.ru/post/301808/

https://habrahabr.ru/post/302160/

https://habrahabr.ru/post/301044/ pagination

http://jinchengli.me/post/postgres-query-opt/

http://madusudanan.com/blog/understanding-postgres-caching-in-depth

https://habrahabr.ru/post/280912/

http://www.postgresql.org/docs/current/static/sql-select.html#SQL-EXCEPT

habrahabr.ru/post/268983 WINDOW FUNCT

https://habrahabr.ru/post/282932/ Expression INdex

http://www.postgresql.biz/download/2013_dublin_bottlenecks.pdf

https://github.com/dhamaniasad/awesome-postgres

https://news.ycombinator.com/item?id=11342695

https://news.ycombinator.com/item?id=11104627

https://github.com/pgexperts/pgx_scripts

https://habrahabr.ru/company/postgrespro/blog/277335/

http://www.zerobugsandprogramfaster.net/essays/3.html

https://github.com/kennethreitz/records python client

https://habrahabr.ru/post/276339/

CLUSTERING

http://habrahabr.ru/post/261457/ postgres cluster

https://habrahabr.ru/company/oleg-bunin/blog/312494/

http://habrahabr.ru/post/269889/ Replication in Postgres and MySQL

http://rachbelaid.com/introduction-to-postgres-physical-storage/

http://blog.nordeus.com/dev-ops/postgresql-locking-revealed.htm

http://phili.pe/posts/postgresql-on-the-command-line/

http://www.craigkerstiens.com/2015/12/29/my-postgres-top-10-for-2016/

https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases-part-ii/

http://russ.garrett.co.uk/2015/10/02/postgres-monitoring-cheatsheet/

http://www.postgresguide.com/

http://habrahabr.ru/post/269497/ recursion

http://goto.project-a.com/postgresql-magic/

http://lwn.net/Articles/653411/

http://jnosal.logdown.com/posts/288762-python

Full text search

https://lo.calho.st/databases/an-idiots-guide-to-fulltext-search-in-postgresql/

http://shisaa.jp/postset/postgresql-full-text-search-part-1.html

http://habrahabr.ru/post/269823/

http://habrahabr.ru/post/268631/

http://habrahabr.ru/post/269849/

http://rhaas.blogspot.co.nz/2015/11/parallel-sequential-scan-is-committed.html

http://patshaughnessy.net/2014/11/11/discovering-the-computer-science-behind-postgres-indexes

http://www.postgresql.org/docs/9.4/static/sql-notify.html LISTEN NOTIFY

Postgres on GPU

http://on-demand.gputechconf.com/gtc/2015/presentation/S5276-Kohei-KaiGai.pdf

https://wiki.postgresql.org/wiki/PGStrom

http://habrahabr.ru/post/263541/

https://www.youtube.com/watch?v=zsF1vfHBMBI&feature=youtu.be

https://news.ycombinator.com/item?id=9738019

http://zamotivator.livejournal.com/622416.html

https://habrahabr.ru/post/304258/

http://blog.codeship.com/following-a-select-statement-through-postgres-internals/

https://blog.codeship.com/discovering-computer-science-behind-postgres-indexes/

Explain plan

http://tatiyants.com/postgres-query-plan-visualization/

http://patshaughnessy.net/2015/11/24/a-look-at-how-postgres-executes-a-tiny-join

https://habrahabr.ru/post/282011/

https://news.ycombinator.com/item?id=10960344

http://www.dalibo.org/_media/understanding_explain.pdf

https://news.ycombinator.com/item?id=11467309

http://habrahabr.ru/post/253017/

https://news.ycombinator.com/item?id=10875076 hierarhy

http://engineering.tilt.com/7-postgresql-data-migration-hacks/

http://dailytechvideo.com/daniel-rocco-pushy-postgres-and-python/

http://blog.2ndquadrant.com/

Arrays

http://blog.lerner.co.il/turning-postgresql-arrays-rows-unnest/ Arrays

http://blog.heapanalytics.com/dont-iterate-over-a-postgres-array-with-a-loop/

https://news.ycombinator.com/item?id=9327216

Books

http://postgresql.leopard.in.ua/ Book: Работа с PostgreSQL

Исходники: github.com/le0pard/postgresql_book

PostgreSQL Server Programming By Hannu Krosing, Kirk Roybal, Jim Mlodgenski 2013

Window functions in Postgres

http://www.gab.lc/articles/window_functions_postgresql.php

http://habrahabr.ru/post/254425/ JSON

Postgress+LLVM

http://vitessedata.com/

https://news.ycombinator.com/item?id=8470754

GUI client

http://postgresapp.com/ om Mac OS X

https://news.ycombinator.com/item?id=8683405

http://habrahabr.ru/post/268867/

http://www.databasesoup.com/

https://github.com/fiksu/partitioned/blob/master/PARTITIONING_EXPLAINED.txt

http://jjinux.blogspot.com/2014/04/pycon-notes-postgresql-proficiency-for.html

http://habrahabr.ru/post/214183/

http://igorsubbotin.blogspot.ru/2014/09/postgresql-94.html

http://obartunov.livejournal.com/175235.html

In 9.3 Hstore stores only string -> string relationships.

https://news.ycombinator.com/item?id=6689702 Hstore development for 9.4 release

http://www.reddit.com/r/programming/comments/1q3skb/postgresql_94_is_now_faster_than_mongodb_for/

In 9.3, querying unindexed fields in JSON column type is painfully slow compared with Mongo, as has to parse the JSON from a string for every row, then do the comparisons.

http://habrahabr.ru/company/mbt/blog/171217/

http://thebuild.com/presentations/pg-as-nosql-pgday-fosdem-2013.pdf

http://stackoverflow.com/questions/18833970/querying-inside-postgres-json-arrays

http://www.slideshare.net/stormdb_cloud_database/postgres-xc-askeyvaluestorevsmongodb

http://www.quora.com/MongoDB/When-i-must-use-MongoDB-instead-of-PostgreSQL-in-web-projects

http://kotov-dev.blogspot.com/2013/02/shemaless-xml-json-postgresql.html

http://geoffreylitt.com/files/Postgres-BSON.pdf

http://obartunov.livejournal.com/tag/pg

http://www.postgresql.org/docs/9.3/static/internals.html

http://www.craigkerstiens.com/2013/06/27/Pivoting-in-Postgres/?

http://www.postgresguide.com/

http://www.craigkerstiens.com/2013/08/05/a-look-at-FDWs/ external data wrapper

http://www.depesz.com/projects/

http://www.slideshare.net/pgconf/the-postgresql-query-planner

http://habrahabr.ru/post/198332/ User-defined Types in Postgres

http://www.neilconway.org/talks/optimizer/optimizer.pdf

http://www.slideshare.net/profyclub_ru/explaining-the-postgres-query-optimizerbruce-momjian

http://www.slideshare.net/koolkampus/ch13

https://sites.google.com/site/robertmhaas/presentations

http://www.datadoghq.com/2013/08/100x-faster-postgres-performance-by-changing-1-line/

http://grokbase.com/t/postgresql/pgsql-general/12axw3f9sv/access-to-postgresql-query-optimizer-output

http://wekeroad.com/2012/07/19/postgresql-rising

http://www.linbrary.com/postgresql/900/ebooks/PostgreSQL_900-Volume_V-Internals_and_Appendixes.pdf

http://www.postgresql.org/docs/devel/static/internals.html

http://momjian.us/main/writings/pgsql/optimizer.pdf

http://momjian.us/main/presentations/internals.html

http://www.pressingquestion.com/2150022/How-To-Learn-Postgresql-And-Its-Internals%3F

http://postgres-bits.herokuapp.com/#1

http://news.ycombinator.com/item?id=4268525

http://momjian.us/main/presentations/overview.html

http://momjian.us/main/blogs/pgblog/2012.html

https://wiki.postgresql.org/images/b/b4/Pg-as-nosql-pgday-fosdem-2013.pdf

https://speakerdeck.com/andrewgodwin/rapid-schema-development-with-postgresql

http://bartek.im/blog/2012/12/04/postgresql-92-streaming-primer.html

http://obartunov.livejournal.com/172503.html HSTORE

http://www.postgresonline.com/

http://wiki.postgresql.org/wiki/PgAdmin_Internals