jkatz05

5 ms·

1.
PostgreSQL 19 Beta 1 Released(postgresql.org)
7 points by jkatz05 4mo ago|0 comments
2.
PostgreSQL 18 Released(postgresql.org)
142 points by jkatz05 1y ago|21 comments
3.
PostgreSQL 18 Beta 1 Released(postgresql.org)
10 points by jkatz05 1y ago|1 comments
4.
PostgreSQL 17(postgresql.org)
661 points by jkatz05 2y ago|148 comments
5.
PostgreSQL 17 Beta 1 Released(postgresql.org)
16 points by jkatz05 2y ago|1 comments
6.
Distributed Queries for Pgvector(jkatz05.com)
5 points by jkatz05 3y ago|1 comments
7.
by jkatz05 3y ago
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.
8.
by jkatz05 3y ago
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 quantizer" (in this case, sampling the entire datase
9.
by jkatz05 3y ago
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 representation of "nearness" across all the data
10.
by jkatz05 3y ago
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 the "--local" flag made it easier to run using the
11.
by jkatz05 3y ago
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 ( https://aws.amazon.com/about-aws&#x2F
12.
PostgreSQL 16 Beta 1(postgresql.org)
154 points by jkatz05 3y ago|60 comments
13.
PostgreSQL 15(postgresql.org)
655 points by jkatz05 4y ago|126 comments
14.
PostgreSQL 15 Beta 1(postgresql.org)
7 points by jkatz05 4y ago|1 comments
15.
Using TimescaleDB with PGO, the Open Source Postgres Operator(blog.crunchydata.com)
18 points by jkatz05 5y ago|0 comments
16.
Projecting Monthly Revenue Run Rate in Postgres(blog.crunchydata.com)
3 points by jkatz05 5y ago|0 comments
17.
by jkatz05 5y ago
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.
18.
by jkatz05 5y ago
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.
19.
PostgreSQL 14(postgresql.org)
941 points by jkatz05 5y ago|284 comments
20.
by jkatz05 5y ago
PostgreSQL 14 made improvements to this area around indexing: https://www.postgresql.org/docs/14/btree-implementation.html...
21.
by jkatz05 5y ago
"@>" 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...
22.
PostGIS at 20, the Beginning(blog.cleverelephant.ca)
302 points by jkatz05 5y ago|32 comments
23.
by jkatz05 5y ago
TDE won't be in 14, but there is ongoing work to try to have it ready for 15.
24.
PostgreSQL 14 Beta 1 Released(postgresql.org)
49 points by jkatz05 5y ago|13 comments
25.
With Queries: Present and Future(info.crunchydata.com)
1 points by jkatz05 6y ago|0 comments
26.
PostgreSQL Benchmarks: Apple Intel MacBook Pro, 2011-2019(info.crunchydata.com)
7 points by jkatz05 6y ago|0 comments
27.
PostgreSQL Monitoring for App Developers(info.crunchydata.com)
16 points by jkatz05 6y ago|0 comments
28.
How to Setup PostgreSQL Monitoring in Kubernetes(info.crunchydata.com)
1 points by jkatz05 6y ago|0 comments
29.
PostgreSQL 13 Upgrade and Performance Check on Ubuntu/Debian(info.crunchydata.com)
3 points by jkatz05 6y ago|0 comments
30.
by jkatz05 6y ago
The PostgreSQL community tries to keep a list of new features that are added in its feature matrix: https://www.postgresql.org/about/featurematrix/ This is not an exhaustive list, but it contains a lot. You would

More ›