23 comments

  • jedberg 5 hours ago ago

    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.

    • chaz6 2 minutes ago ago

      What gets me is that by default the id counter starts at 1 rather than -9223372036854775808 (for BIGINT) so you have immediately lost half of the space.

    • craigkerstiens 4 hours ago ago

      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.

  • throwitaway222 5 hours ago ago

    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 5 hours ago ago

      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 5 hours ago ago

      because clicks

  • mmh0000 6 hours ago ago

    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.

  • heavensteeth 5 hours ago ago

    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.

  • Avalaxy 2 hours ago ago

    Very cool! We're using Lakebase, looking forward to try the new REPACK feature.

  • undefined 3 hours ago ago
    [deleted]
  • rixed 5 hours ago ago
  • smallerize 9 hours ago ago

    Article doesn't mention Neon. What does Neon mean in this context?

    • flowerlad 6 hours ago ago

      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 6 hours ago ago

        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 5 hours ago ago

          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 5 hours ago ago

          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 9 hours ago ago

      Neon db was acquired by Databricks. Companion blog: https://neon.com/blog/postgres-19-is-out-try-it-on-neon

    • gnabgib 9 hours ago ago

      Neon provided a semi-compatible serverless postgres (667 points, 2022, 330 comments)https://news.ycombinator.com/item?id=31536827

      Before databricks purchased

    • gabinator 6 hours ago ago

      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 5 hours ago ago

        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 5 hours ago ago

        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.

  • cpursley 3 hours ago ago

    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.