Matthias van de Meent

## Lists of features that would be useful ### Correctness - VACUUM support ### Performance - Deduplicate vectors (like GIN & btree) - Implement IVF-flat, with clusters stored in btrees,...

Smgr extension API

5

Introduce an SMGR API to PostgreSQL that Neon could plug into. Anastasia started a thread on that here: https://www.postgresql.org/message-id/CAP4vRV6JKXyFfEOf%3Dn%2Bv5RGsZywAQ3CTM8ESWvgq%2BS87Tmgx_g%40mail.gmail.com New Redux thread[^1] in commitfest[^2] [^1]: https://www.postgresql.org/message-id/flat/CAEze2WgMySu2suO_TLvFyGY3URa4mAx22WeoEicnK=PCNWEMrA@mail.gmail.com [^2]: https://commitfest.postgresql.org/43/4428/

Handle PS error responses cleanly

2

Before this, we'd assume the PS connection would be good once we got a response. Now, we also check that the response was a positive one. This means our exponential...

Improve the memory usage of our own HLL implementation

1

We don't use sliding windows, so we can just drop the historical snapshot requirement from the implementation, thus removing the 50%+ tracking overhead. A nice benefit is that this allows...

Add bench functions for GIN-based TSQuery/TSVector

2

# Ticket(s) Closed Not closed, but some part of https://github.com/paradedb/paradedb/issues/279 is definitely addressed here. ## What Add a benchmark option for PG's native text search capabilities ## Why The benchmark...

Use debug logging for normal operations in network setup

1

This reduces log rate by a good margin, while still keeping enough info in logs for debugging if and when errors occur.

The program has been cancelled, as per https://dearmoon.earth and the linked notice https://dearmoon.earth/pdf/dearMoon_EN_240601.pdf?0531

[compute/postgres] feature: PostgreSQL 17

1

## Problem We don't yet support PostgreSQL v17 ## Summary of changes Initial PG17 support, based on https://github.com/postgres/postgres/commit/3256722d7b7ff64918a0e5fdf6140de355147fe6 - [x] Rebase our changes on top of v17 - [x] Get...

Run tests on a parallel schedule

1

This reduces total runtime by using more available CPU resources.

Add test for replica promotion

3

This validates that replicas can promote, and start write changes, and that these changes are also persisted. However, this does not check any less-than-happy paths. Postgres submodules PRs: https://github.com/neondatabase/postgres/pull/648 https://github.com/neondatabase/postgres/pull/649...