PostgreSQL writings

• Postgres Innovations, PGConf.Nepal, Kathmandu University, May 11, 2023
• New TOAST in TOWN. One Toast Fits All., PGMeetup, Nizhny Novgorod, Sep 21, 2022
• TOAST LARGE OBJECTS, PGConf.RU-2022, Jun 21, 2022
• SQL/JSON and Beyond (JSON_MODIFY), PGConf.RU-2022, Jun 20, 2022
• New TOAST in TOWN. One Toast Fits All., PGCON-2022, May 27, 2022
• One TOAST Fits All. Pluggable TOAST., Moscow, Hihgload++, May 13, 2022
• Understanding Jsonb performance, NYC, PGCONF.NYC, Dec 2, 2021
• K-Nearest Neighbors Search in PostgreSQL, Moscow PGConf.ru, Oct 25,2021
• JSON OR NOT JSON (V2), Meetup Nizhny Novgorod, Oct 1, 2021
• JSON OR NOT JSON, Highload SPB 2021, Sep 20, 2021
• Scaling Jsonb,Postgres Vision 2021, online, June 22, 2021
• Postgres Universal Database (2021), Воронеж, May 28 2021
• Jsonb on steroids,Highload 2021, Moscow, May 7 2021
• JSONB internals,PGConf.Online 2021, Mar 1 2021
  Video (mp4)
• Appendable bytea TOAST,PGConf.Online 2021, Mar 3 2021
• Speedup the JSONB. What we can do to improve performance,Fosdem 2021, Feb 8, 2021
  Video (mp4)
• JSON[B] Roadmap V3, Postgres Build 2020, Dec 8, 2020
  Video (mp4)
• JSON[B] Roadmap V2, Postgres Professional Webinar, Sep 17, 2020
• JSON[B] Unification,Database Meetup, 25 Июня, 2020
• JSON[B] Roadmap,PGCon-virtual, May 28, 2020
• Full Text Search in PG12,PGConf.in, Bengaluru, Feb 27, 2020
• Что нового в PG13,Тюмень, Feb 7, 2020
• Энциклопедия полнотекстового поиска,PgCONF.RU, Feb 5, 2020
• All You Need Is Postgres,Postgres@CERN, Jan 17, 2020
• PostgreSQL 12,PGConf.Syberia, Nov 12, 2019
• PostgreSQL 12,Highload, Nov 8, 2019
• Future of databases,HSE, Oct 28, 2019
• May the Force of hierarchical data be with you. Ltree,Milan, Oct 16, 2019
• Jsonpath (v5),Milan, Oct 16, 2019
• PostgreSQL 12 в этюдах (Latest version), IT-Nights, Innopolis Aug 1, 2019
• Jsonpath - a query language for json (v4),Beijing, Jul 4, 2019
• Jsonpath - a query language for json (v3),PGIbiz, Ibiza, May 24, 2019
• Viva, the NOSQL Postgres. Jsonpath - a query language for json,PGCon, Ottawa, May 31, 2019
• Jsonpath - a query language for json,PGDay.IT, Bologna, May 17, 2019
• PostgreSQL 12 в этюдах (Latest version), Na Stachke, Apr 28, 2019
• PostgreSQL 12 в этюдах, Highload Saint Petersburg, Apr 9, 2019
• What's new in PostgreSQL 12 ?, PGDay.il 2019, Tel Aviv, March 14, 2019
• Что PostgreSQL 12 нам готовит ?, PGConf.RU 2019, Moscow, Feb 5, 2019
• Professional Postgres, PGConf.RU 2019, Moscow, Feb 5, 2019
• Эволюция СУБД, Красноярск, Nov 18, 2018
• Do you need a Full-Text Search in PostgreSQL, PGConf.EU 2018, Lisbon, Oct 26, 2018
• SQL/JSON in PostgreSQL, PGOpen, Beijing, June 28, 2018
• Новые возможности PostgreSQL 11, Ростов, 1 Июня, 2018
• Nepali Support for FTS in PostgreSQL, by Ingroj Shrestha, PGConf.Nepal, Kathmandu, May 4, 2018
• PostgreSQL Universal Database, PGConf.Nepal, Kathmandu, May 4, 2018
• Jsonb "smart" indexing. Parametrized opclasses., PGCON, Ottawa, May 28, 2018
• Jsonb "smart" indexing. Parametrized opclasses., PGCONF.RU, Moscow, Feb 6, 2018
• Viva, NoSQL Postgres, Fosdem, Brussels, Feb 4, 2018
• PostgreSQL Universal Database, PGConf.Asia, Tokyo, Dec 5, 2017
• Оптимизация high-contention write в PostgreSQL, HighLoad++, Москва, Nov 7, 2017
• Jsonb roadmap, PGConf EU, Warsaw, Oct 27, 2017
• PostgreSQL 10, HSE, Moscow, Oct 5, 2017
• PostgreSQL 10, Tel Aviv, Sep 8, 2017
• NoSQL PostgreSQL (corrected version), UFAdevConf, UFA,Oct 14, 2017
• Postgres для Хипстеров, DevConf, Москва, June 16, 2017
• Postgres vs Mongo, RitConf, Москва, June 6, 2017
• Карьера в Open Source, KGU, Elista,Apr 27, 2017
• NoSQL Postgres(full version), Stachka-2017,Ulyanovsk, Apr 4-15, 2017
• Postgres вчера, сегодня, завтра, Innopolis,Иннополис, 6 апреля 2017
• JSON in Postgres - The present and Future,PGConf.US 2017,Jersey City, US, Mar 30,2017
• Postgres: Past, Present, Future,March 2, 2017, Tel Aviv, Israel
• CREATE INDEX ... USING RUM,FOSDEM, Brussels, Belgium, Feb 1, 2017
• Научные вызовы анализу данных,DataFest, Москва, Feb 12, 2017
• Spatial indexes in PostgreSQL for astronomy,ADASS-2016,Trieste,Italy,Oct 18,2016
• PostgreSQL 9.6. New advances in Full Text Search., The Computing Conference, Hangzhou, China, Oct 16, 2016
• Better Full Text Search in PostgreSQL, PGConf.EU,Tallinn, Nov 4, 2016
• Russian Contribution to Postgres
• Postgres Innovations. Beyond high performance and availability., Postgres Vision,San Francisco, Oct 12, 2016
• Новые возможности полнотекстового поиска в PostgreSQL, Highload-2016,Москва, 8 ноября, 2016
• FTS meetup at Highload-2016, Highload-2016,Москва, 8 ноября, 2016
• CREATE INDEX ... USING RUM. RUM index and its applications to FTS., Postgres Open 2016, Dallas, Sep 14, 2016
• Последние новости постгреса с PGCon, RIT-2016, Москва,1 июня 2016
• FTS is dead ? Long live FTS ! New features of Full-text search in PostgreSQL, PGCon-2016, Ottawa, May 19, 2016
• Postgres вчера, сегодня, завтра V2, Стачка-2016, Ульяновск, Apr 23, 2016
• Карьера в Open Source, SECON 2016, Penza, Apr 22, 2016
• Postgres вчера, сегодня, завтра V1, DUMP 2016, Ekaterinburg, Apr 8, 2016
• Настоящее и будущее PostgreSQL, Codefest 2016, Novosibirsk, Mar 26-27, 2016
• Author's view on unstructured data in PostgreSQL, PGbr 2015,Porto Alegre, Brazil, Nov 18-20, 2015
• Full-Text Search in PostgreSQL by authors, PGbr 2015,Porto Alegre, Brazil, Nov 18-20, 2015
• Cluster Saga, Highload 2015, Moscow, Nov 3-4, 2015.
• Access method extendability in PostgreSQL or back to origin, PGConf.EU 2015, Vienna, Oct 28, 2015.
• Rethinking JSONB, PGCon 2015, Ottawa, June, 2015.
• PostgreSQL 9.4: NoSQL on ACID, Secon 2015, Penza, Apr 24, 2015.
• NoSQL for PostgreSQL: Jsquery, Codefest 2015, Novosibirsk, March 28-29, 2015.
• VODKA connecting Indexes, Highload 2014, Moscow, Oct 31, 2014.
• JsQuery-the jsonb query language with GIN indexing support, PostgreSQL Conference Europe 2014, Madrid, Oct 25, 2014.
• Everything Indexes (v4), Avito meetup, Moscow, Oct 15, 2014.
• Schema-less PostgreSQL. Current and Future., Tokyo, Sep 11, 2014.
• GIN - Stronger than ever(Slides),PGCon-2014, May 22, 2014, Ottawa,Canada.
• CREATE INDEX ... USING VODKA. An efficient indexing of nested structures,(Slides),PGCon-2014, May 22, 2014, Ottawa,Canada.
• Everything Indexes (v3), Sankt-Petersburg, Apr 23, 2014.
• Schema-less PostgreSQL и другие новости 9.4, Mar 14, 2014, RIT-2014, Moscow, Russia
• Слабо-структурированные данные в PostgreSQL и другие новости 9.4, Mar 29, 2014, Codefest-2014, Novosibirsk, Russia
• Next generation of GIN, PostgreSQL Conference Europe 2013, Oct 29-Nov 1, 2013, Dublin, Ireland.
• Binary storage for nested data structures and application to hstore data type, PostgreSQL Conference Europe 2013, Oct 29-Nov 1, 2013, Dublin, Ireland.
• Вся правда об индексах в PostgreSQL, Highload++ conference, Oct 28-Nov 1, 2013, Moscow, Russia
  Вся правда об индексах в PostgreSQL: revised,
• Nested hstore with arrays support, PGCon-2013 conference, May 24, 2013, Ottawa, Canada
• Расширяемость PostgreSQL для хакеров и архитекторов,РИТ++, 2013, Москва
  Расширяемость PostgreSQL: revised
• "Анатомия" полнотекстового поиска в PostgreSQL тезисы, слайды, для TitConf, Тверь, 12 апреля 2013.
• PostgreSQL Conference Europe 2012, Prague, Oct 23-26, 2012.
• Full-text search in PostgreSQL in milliseconds, PostgreSQL Conference Europe 2012, Prague, Oct 23-26, 2012.
• Полнотекстовый поиск в PostgreSQL за миллисекунды, Highload++, Москва, октябрь 21, 2012.
• Finding Similar.Effective similarity search in database, PGCon-2012 conference, Ottawa, Canada.
• Требования к Национальной СУБД для совещания по НПП. См. также статью в CNews.
• Неточные данные в эпоху BIG DATA, Abrau 2011
• SP-GiST - a new indexing infrastructure for PostgreSQL. Space-Partitioning trees in PostgreSQL с PGCon-2011 conference, Ottawa, Canada.
• Слайды Эффективный поиск ближайших соседей в PostgreSQL, РИТ, Москва.
• Presentation Efficient k-nn search with GiST and other development on PGday 2010, Roma, Italy.
• Presentation Efficient k-nn search with GiST and other development on PGCon-2010, Ottawa, Canada.
• Астрономические вызовы технологиям СУБД с Иваном Золотухиным для РИТ++/2010
• Слайды Научные вызовы технологиям СУБД для Корпоративные базы данных
• Листовка Научные вызовы технологиям СУБД для Корпоративные базы данных
• Что нового в PostgreSQL 9.0 для Корпоративные базы данных
• Some recent advances in full-text search PGCon 2009, Ottawa, Canada, may 21-22, 2009
• Algebra for full-text search (Part I)
  Algebra for full-text search (Part II)
  "Problem in modern informational system" seminar, MSU, 2008
• Text Search in 8.4+ For European PGDay 2008, Prato, Italy
• Extendability of PostgreSQL For Moscow ACM SIGMOD Chapter
• PostgreSQL GIN improvements (multicolumn, fast update, partial match) - For PGCon2008 conference
• Hstore- key-value storage in PostgreSQL for PGCon2007, Ottawa, Canada
• PostgreSQL 8.4 Development Plans - The Dark Rumours from -hackers and -patches ! ( For CBD-2008 )
• FTSBOOK (PDF ) - "Gentle Introduction to the FTS in PostgreSQL" - Obsoleted by Official Documentation
• Specialized data types for Digital Libraries (in Russian) - for RCDL 2007.
• Full-text search in PostgreSQL - advanced lecture (.pdf) PGDay2007, Prato, Italy
• Full-text search in PostgreSQL - advanced lecture (.pdf) PGCon2007, Ottawa, Canada
• Anatomy of Astronet, SAO 2007.
• Введение в полнотекстовый поиск в PostgreSQL - для конференции Корпоративные базы данных-2007
• Полнотекстовый поиск в PostgreSQL - 30-минутная презентация (.pdf) для RIT-2007
• Написание расширений для PostgreSQL с использованием GiST - тезисы доклада для конференции разработчиков свободных программ Протва-2005 (English version)
• Тезисы доклада "Что такое PostgreSQL" для конференции Корпоративные базы данных-2005 (PDF)
• PostgreSQL summary - небольшая листовка
• Тезисы доклада для конференции Корпоративные базы данных-2006
• GIN - generalized inverted index для PostgreSQL Anniversary Summit, Toronto, 2006
• Tsearch2 - full text search extension to PostgreSQL для PostgreSQL Anniversary Summit, Toronto, 2006