I used Postgres since 1995 ( [PG95] mailing list has less than 400 subscribers !) for my scientific projects and operating with numbers and english strings was smooth, but in 1996 I signed up to make a searchable database of electronic archive of "Uchitelskaya gazeta" ( the popular newspaper for teachers community). It was my moonlight work to help ( Read more... )

After ten years of working with postgres ( actually, I started with Ingres, then postgres95), I and Teodor got a chance to see live other developers.  We presented there GIN and FTS.  Pictures from the Anniversary Summit at at Ryerson University in Toronto can be  viewed on the flickr under name  PGCon-2006, I hope many of us will enjoy looking ( Read more... )

( Read more... )

Andrew Dunstan committed SQL_JSON - one of the most awaited part of remaining part of SQL/JSON standard, which our team in Postgres Professional were working since early 2017, the first version was presented in our talk at PGConf.eu - 2017. Kudos, Andrew, you helped us with committing jsonb and help now ( Read more... )

I didn't informed by postgres community that I (as all russians) was removed from the list of GSoC mentors and very dissapointed of that. I was Google mentor in the very first year (2006) of GSoC and that time I cannot imagine I will be "sanctioned" by Google. In the early time of open source we believed, that we are building a new model of ( Read more... )

Finally, we made License for jsonb toaster.

We use this license to make our software available for all PostgreSQL users without limitations. If required user may adapt software for internal use. On the other hand we limit usage of our software for SaaS and DBaaS services.

I would be grateful for comments.

( Read more... )

We have submitted TOAST API for PG15.

Below is a performance analysis of JSONB, which uses JSONB TOASTER implemented using TOAST API.

Each jsonb looks like: key1, looong key2[], key3, loong key4[]. Check slide #10 of our talk at pgvision 2021 for description of data and queries used in benchmarks ( Read more... )

Inspired by commit support for partial TOAST decompression"When asked for a slice of a TOAST entry, decompress enough to return the slice instead of decompressing the entire object ( Read more... )

"Instead of WAL-logging every modification during the build separately ( Read more... )

1. Полный список задач с описаниями для некоторых доступен https://docs.google.com/document/d/1wzDlMF7NkZZC4Kp6m6KRaYeaSYyU6tKvRkDUlKOyCjs/

2. Список ресурсов для начинающих разработчиков PostgreSQL
https://obartunov.livejournal.com/195274.html3. Решить задачу - это написать код, тесты (функциональные, производительность), документацию ( Read more... )