jkatz05 Profile Banner
Jonathan S. Katz Profile
Jonathan S. Katz

@jkatz05

Followers
3K
Following
4K
Media
123
Statuses
4K

Principal Product Manager Technical - @AWSCloud, @PostgreSQL Core Team member. Helping people to adopt and learn @PostgreSQL! Opinions are my own.

New York
Joined November 2008
Don't wanna be here? Send us removal request.
@PGConfdev
PGConf.dev 🐘
8 months
It's not too soon to think about registering for https://t.co/TfE6OMMkHR! The program hasn't been announced yet but we promise it will be absolutely amazing, and the hallway track will be fabulous too. Hope you can join us!
2025.pgconf.dev
PostgreSQL Development Conference, an annual event for developers of PostgreSQL.
0
3
8
@PGConfdev
PGConf.dev 🐘
8 months
Happy New Year! There are only a few days left to submit your proposals to #PGConfdev 2025. CFP closes January 6th! https://t.co/qIBAExiTAw #postgresql
2025.pgconf.dev
PostgreSQL Development Conference, an annual event for developers of PostgreSQL.
1
4
7
@melanieplageman
Melanie Plageman
9 months
My holiday wish is that we will get loads of great submissions to the https://t.co/glTVNhuCjQ 2025 CFP (by Jan 6). Check out @robertmhaas’s great blog post for ideas on what to submit and why.
2025.pgconf.dev
PostgreSQL Development Conference, an annual event for developers of PostgreSQL.
@planetpostgres
Planet PostgreSQL
9 months
Robert Haas (@robertmhaas): https://t.co/NtuIjmdaBY needs your submissions!
0
5
12
@PGConfdev
PGConf.dev 🐘
9 months
The 2025 CFP deadline is now January 6th! Procrastinators rejoice! We heard many of you get your best ideas during an end-of-year break, so we've extended the 2025 CFP to January 6th. Consider it a gift from the organizing team to you ;)
2025.pgconf.dev
PostgreSQL Development Conference, an annual event for developers of PostgreSQL.
0
8
15
@dave_cramer
Dave Cramer πŸ‡¨πŸ‡¦
9 months
1
5
13
@jkatz05
Jonathan S. Katz
10 months
Not often there's two @PostgreSQL update releases in a row - but we should be good until the regularly scheduled one in February. And this is really the last release of PostgreSQL 12 ;-)
Tweet card summary image
postgresql.org
The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 17.2, 16.6, 15.10, 14.15, …
0
5
13
@jkatz05
Jonathan S. Katz
10 months
You don't deploy on a Friday, but you announce out-of-cycle releases for the following week. If you're dependent on `ALTER ROLE ... SET ROLE` in in @PostgreSQL your workflow, hold off on upgrading until this next release comes out.
@PostgreSQL
PostgreSQL
10 months
News: Out-of-cycle release scheduled for November 21, 2024
0
2
10
@josepheconway
Joseph Conway
10 months
PostgreSQL 17.1, and all of the other updated minors released this morning by the PostgreSQL community, are now available on Amazon RDS for you! https://t.co/P88Wi33aNa
aws.amazon.com
0
4
30
@jkatz05
Jonathan S. Katz
10 months
Happy and sad day - @PostgreSQL 17.1 is now out (so you should upgrade to that πŸ˜‰), but sad to see @PostgreSQL 12 now EOL - that was a great performance release, so thanks for the memories!
@PostgreSQL
PostgreSQL
10 months
News: PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 Released!
2
4
33
@jkatz05
Jonathan S. Katz
10 months
I've published my @PGConfEU 2024 talk slides on @pgvector internals, aka "Dissimilarity search: implementing in-memory vector search algorithms to @PostgreSQL" (though pgvector 0.8.0 means I already have to update the deck!):
Tweet card summary image
postgresql.eu
Dissimilarity search: implementing in-memory vector search algorithms to PostgreSQL
0
0
18
@jkatz05
Jonathan S. Katz
10 months
This @pgvector release gives you more options for efficient, performant filtering (WHEREs, JOINs) and tools to avoid the "overfiltering" problem. You may find using a @PostgreSQL B-tree, GiST, or GIN index does the trick with filters! Also, HNSW lookups are just faster πŸš€.
@PostgreSQL
PostgreSQL
10 months
News: pgvector 0.8.0 Released!
1
8
42
@PGConfdev
PGConf.dev 🐘
11 months
#PGConfdev 2025 Call for Proposals is now open! https://t.co/qIBAExilKY We are accepting proposals for 25-minute talks, 50-minute talks, and alternative content (like panels, summits, and any other creative ideas)! We can't wait to read your #PGConfdev2025 proposal! #PostgreSQL
2025.pgconf.dev
PostgreSQL Development Conference, an annual event for developers of PostgreSQL.
0
9
15
@pgconfnyc
pgconfnyc
11 months
PGConf NYC would like to thank everyone who attended our conference! We hope you enjoyed the content we presented and that we’ll see you at future events! @PostgreSQL #PostgreSQL #postgres #pgconfnyc
Tweet media one
0
3
10
@jkatz05
Jonathan S. Katz
1 year
Congrats to all the hard work of the @PostgreSQL community on PostgreSQL 17! Amazing how PostgreSQL continues to get faster and more fun to use :)
@PostgreSQL
PostgreSQL
1 year
News: PostgreSQL 17 Released!
1
17
118
@pgconfnyc
pgconfnyc
1 year
Time is running out! We’re looking for sponsors for PGConf NYC 2024! Let your company know asap! https://t.co/CVLtQYMqTg @PostgreSQL #PostgreSQL #postgres #pgconfnyc
Tweet media one
0
4
5
@planetpostgres
Planet PostgreSQL
1 year
Jonathan Katz (@jkatz05): Hybrid search with PostgreSQL and pgvector
jkatz05.com
An example of how to perform hybrid search with PostgreSQL and pgvector over vector data.
0
12
44