PostgreSQL Begins Landing LLVM JIT Support For Faster Performance

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • phoronix
    Administrator
    • Jan 2007
    • 67366

    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
  • clockley1
    Junior Member
    • Jun 2015
    • 13

    #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

    • Chewi
      Senior Member
      • Jun 2008
      • 1043

      #3
      This = awesome.

      Comment

      • misp
        Phoronix Member
        • Oct 2013
        • 89

        #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

        • Chewi
          Senior Member
          • Jun 2008
          • 1043

          #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

          • ctwise
            Junior Member
            • Mar 2012
            • 11

            #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

            • fuzz
              Senior Member
              • Apr 2012
              • 864

              #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

              • coder111
                Senior Member
                • Oct 2012
                • 198

                #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

                • andrei_me
                  Senior Member
                  • Sep 2013
                  • 1203

                  #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

                  • uid313
                    Senior Member
                    • Dec 2011
                    • 6921

                    #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