Announcement

Collapse
No announcement yet.

PostgreSQL Begins Landing LLVM JIT Support For Faster Performance

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • PostgreSQL Begins Landing LLVM JIT Support For Faster Performance

    Phoronix: PostgreSQL Begins Landing LLVM JIT Support For Faster Performance

    The widely-used PostgreSQL database software may soon become much faster thanks to a work-in-progress LLVM JIT back-end that has begun to land...

    Phoronix, Linux Hardware Reviews, Linux hardware benchmarks, Linux server benchmarks, Linux benchmarking, Desktop Linux, Linux performance, Open Source graphics, Linux How To, Ubuntu benchmarks, Ubuntu hardware, Phoronix Test Suite

  • #2
    One has to wonder how much further the FOSS ecosystem would have progressed if GCC had a modular codebase and a different licence. While GCC may emit better code no one else can use the technology.

    Comment


    • #3
      This = awesome.

      Comment


      • #4
        Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
        Anyone knows if this changed?

        Comment


        • #5
          Originally posted by misp View Post
          Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
          Anyone knows if this changed?
          There is pgAdmin. It's okay, not great, but I'm not very interested in GUI tools anyway.

          Comment


          • #6
            Originally posted by misp View Post
            Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
            Anyone knows if this changed?
            There are query tools that aren't postgresql specific or open-source. DataGrip from JetBrains is an example.

            Comment


            • #7
              Originally posted by Chewi View Post

              There is pgAdmin. It's okay, not great, but I'm not very interested in GUI tools anyway.
              The new pgAdmin 4 is far better than the older desktop version, pgAdmin 3.

              Comment


              • #8
                There's plenty Java/JDBC based tools that can work with multiple databases that also work nicely with PostgreSQL specific functionality.

                Squirrel SQL is quite nice: http://www.squirrelsql.org/

                DBeaver is freemium: https://dbeaver.jkiss.org/

                There's SQL workbench (never used it): http://www.sql-workbench.eu/

                DBVisualizer (freemium): http://www.dbvis.com/

                Heidi SQL: https://www.heidisql.com/

                And there's always default tools: command line psql and pgadmin3.

                Also, IDEs like Eclipse, Netbeans, Jetbrains IntelliJ have tools to connect to a database and query it.

                Originally posted by misp View Post
                Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
                Anyone knows if this changed?

                Comment


                • #9
                  Originally posted by misp View Post
                  Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
                  Anyone knows if this changed?
                  Can't say for sure, but I get used to using psql.

                  I've added to my bash_rc PAGER="less -S" then they results of psql are easier to read.

                  Also the tab autocomplete isn't that awful once you get used to it

                  Comment


                  • #10
                    Is the data type nvarchar part of the SQL standard? Or is it a proprietary data type?

                    PostgreSQL does not support the nvarchar data type, however all columns are Unicode anyways. But it means SQL scripts does not work and cant be imported without modifying the script and changing nvarchar to varchar. 😢

                    The SQL:2016 standard added support for JSON. PostgreSQL have JSON support, but its non-standard. 😢

                    PostgreSQL scatters binaries all over my /usr/bin/ directory. 😢

                    Comment

                    Working...
                    X