| ▲ | Postgres 19 is out, and it's available on Neon and Databricks Lakebase(databricks.com) |
| 59 points by sp_from_db 7 hours ago | 20 comments |
| |
|
| ▲ | jedberg 2 hours ago | parent | next [-] |
| REPACK is my favorite new feature. Vacuum was the bane of my existence when I ran Postgres at reddit. Partly because I didn't know what vacuum was for the first two years. So I thought, "huh, every time vacuum runs it slows down, I should turn this off". Yeah it was dumb to not even google what it was for. About two years in, I hit the point where I ran out of row IDs, and that's when I finally learned what vacuum was for (and reddit was down for a bunch of hours). Having REPACK would have been a godsend. |
| |
| ▲ | craigkerstiens 2 hours ago | parent [-] | | Ha, you're not alone to have gone through "autovacuum slows things down let's turn it off". Yes, it's fundamental to how Postgres works, yes it's a pain in the ass so often. I was so worried to talk much about repack when things started getting reverted. This felt like the riskiest thing of all the headline features in PG19 in my view. Not the graph support, not the split/merge partitions, not group by for all, repack felt like it wouldn't make it lone behold it was the one that did survive of so many headline features. Fingers crossed all the others hold up for PG20 and it ends up as packed with features as 19 was looking like, but at least for now we got repack. |
|
|
| ▲ | Avalaxy 12 minutes ago | parent | prev | next [-] |
| Very cool! We're using Lakebase, looking forward to try the new REPACK feature. |
|
| ▲ | throwitaway222 3 hours ago | parent | prev | next [-] |
| It's very odd that both Snowflake and Databricks (two competitors) have a postgres 19 release announcement in the same 4 hour window and both have been updated but both companies barely ever gets comments on hacker news. It's definitely being upvoted by employees. |
| |
| ▲ | craigkerstiens 3 hours ago | parent | next [-] | | Submitter and author of one of the two posts you talk about. I noticed this PG19 and submitted the one I authored because it hadn't had uptake here. Snowflake definitely historically has not been on HN much, but every place I've built and run Postgres at (Heroku, Citus, and Crunchy Data) we've always tried to focus on high quality content and education, we're very focused on doing the same at Snowflake so I hope you see quite a bit more of it from us here - but my goal is very much to focus on things HN cares about as a long time community member. If you do have feedback on the repack post would love to hear it. | |
| ▲ | tjwebbnorfolk 3 hours ago | parent | prev [-] | | because clicks |
|
|
| ▲ | mmh0000 4 hours ago | parent | prev | next [-] |
| I’ve been super excited for this release! There’s a lot of performance improvements in 19. Now I just have to wait for AWS to launch it. |
|
| ▲ | rixed 3 hours ago | parent | prev | next [-] |
| Better link: https://www.phoronix.com/news/PostgreSQL-19-Released |
|
| ▲ | heavensteeth 3 hours ago | parent | prev | next [-] |
| Unfortunate that the only post of this announcement on HN is to a third-party offering to sell you Postgres for a fee and not the official announcement itself. |
|
| ▲ | cpursley an hour ago | parent | prev | next [-] |
| I just wanna say how pleased I am with neon and how stable it’s been for my Postgres hosting. It’s really nice not having to think about things like scaling and operations. It just works, and importantly - supports the WAL. |
|
| ▲ | smallerize 7 hours ago | parent | prev [-] |
| Article doesn't mention Neon. What does Neon mean in this context? |
| |
| ▲ | flowerlad 4 hours ago | parent | next [-] | | Go to https://neon.new/ and click "Try it in the browser". That's it, with that one click you now have a Postgres instance you can use for 72 hours. If you want to keep it forever you can "claim" it. Thanks to their ability to "scale to zero" if your usage is low, the database is free. | | |
| ▲ | JoshTriplett 4 hours ago | parent [-] | | How does that compare to Aurora Postgres, which can do the same thing? (If it's just "Aurora Postgres, but you can run it on not-AWS", that's still a useful product. But do they have advantages other than that?) | | |
| ▲ | jedberg 3 hours ago | parent | next [-] | | Biggest differences are that Neon can scale to zero (and not charge you) and it has branching as a native concept. This means that it can provision a new DB nearly instantly (as opposed to waiting a few minutes for Aurora) and it can do instant copy on write branching. So Neon is a lot better for AI agents that are running experiments. | |
| ▲ | flowerlad 3 hours ago | parent | prev [-] | | Aurora Postgres does not have a free tier, unlike Neon. AWS has a $100 free tier across all services for 12 months, but Neon is free forever as long as your usage is low. |
|
| |
| ▲ | sp_from_db 7 hours ago | parent | prev | next [-] | | Neon db was acquired by Databricks. Companion blog: https://neon.com/blog/postgres-19-is-out-try-it-on-neon | |
| ▲ | gnabgib 7 hours ago | parent | prev | next [-] | | Neon provided a semi-compatible serverless postgres (667 points, 2022, 330 comments)https://news.ycombinator.com/item?id=31536827 Before databricks purchased | |
| ▲ | gabinator 4 hours ago | parent | prev [-] | | You could've googled Neon, and the hosted-db provider shows up before the noble gas. This, coupled with the replies to your comment, reeks of an astroturfing post for Databricks. | | |
| ▲ | smallerize 3 hours ago | parent | next [-] | | My first thought was ARM Neon, but I had to check that it wasn't related to the new Gemini model. That SEO is kind of impressive actually. I do think it's weird that so many people replied with the same answer. | |
| ▲ | plorkyeran 3 hours ago | parent | prev [-] | | The google results for "Neon" for me are https://www.neonrated.com followed by news stories about the new Gemini model, followed by the wikipedia article on the noble gas. Nothing related to postgres in any way appears on the first page for me. |
|
|