Viewing profile — jkatz05

git diff REL_16_RC1..REL_16_0 doesn't show any changes that would require a pg_upgrade (at least from my read), so you should be able to upgrade without it.

Blog author. I've done some separate testing on storing ~500GB of embeddings (~1B embeddings) in a partitioned table. The partition key was built using IVFFLAT as a "coarse quantiz…

Blog author. You can choose to use any distance metrics. One reason cosine similarity is popular (and used) is that for many of these higher dimensional datasets, it gives a better…

Blog author. Thanks for the analysis -- I agree that the ANN Benchmark does provide a nice framework for helping with apples-to-apples comparisons. In this case, being able to use …

Hey, I helped to write the original article, and I also work at AWS. I'm happy to let you know that PostgreSQL 16 Beta 1 is available in the Amazon RDS Database Preview Environment…

Multiranges are one of the lead items in the news release :) I do agree that they are incredibly helpful and will help to reduce the complexity of working with ranges.

I'd be curious to see if the concurrency improvements in PostgreSQL 14 help with increasing the threshold for when you need to introduce a connection pooler.

PostgreSQL 14 made improvements to this area around indexing: https://www.postgresql.org/docs/14/btree-implementation.html...

"@>" is one of the operators for the GIN index, which is what Postgres uses for the JSONB type. Ref: https://www.postgresql.org/docs/current/gin-builtin-opclasse...

TDE won't be in 14, but there is ongoing work to try to have it ready for 15.