PostgreSQL related writings

PostgreSQL writings

The True Story of Slonik, pgconf.ru, Moscow,April 1, 2025
Про Postgres и Опенсорс, Pre-Commitfest, SPB,June 24, 2024
Карьера в Опенсорс, Стачка,Ульяновск, Sep 14, 2023
Сцилла и Харибда Open Sourceс, Стачка,Ульяновск, Sep 15, 2023
Postgres Innovations, PGConf.Nepal, Kathmandu University, May 11, 2023
Профессиональный Postgres,Tashkent, Uzbekistan , Mar 30 2022
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

Контакты: Олег Бартунов, http://www.sai.msu.su/~megera/