Announcement

Collapse
No announcement yet.

An Early Look At The Features Of PostgreSQL 9.6

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

  • An Early Look At The Features Of PostgreSQL 9.6

    Phoronix: An Early Look At The Features Of PostgreSQL 9.6

    PostgreSQL 9.6 isn't being released until later this year, but with it moving along, the release notes are starting to be assembled for this next major update to this open-source SQL server implementation...

    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
    The release notes are also available as html:

    Comment


    • #3
      And it clutters your file system with lots of files in your /bin folder.

      Code:
      $ pg
      pg                 pg_dumpall         pgmnorm            pg_recvlogical
      pg_archivecleanup  pg_isready         pgmoil             pg_renamecluster
      pg_basebackup      pg_lsclusters      pgmramp            pgrep
      pgbench            pgmbentley         pgmslice           pg_restore
      pg_config          pgmcrater          pgmtexture         pg_updatedicts
      pg_conftool        pgmedge            pgmtofs            pg_upgradecluster
      pg_createcluster   pgmenhance         pgmtolispm         pg_virtualenv
      pg_ctlcluster      pgmhist            pgmtopbm           
      pg_dropcluster     pgmkernel          pgmtoppm           
      pg_dump            pgmnoise           pg_receivexlog
      Also not everything is prefixed pg*.
      Last edited by uid313; 07 May 2016, 03:55 PM.

      Comment


      • #4
        Originally posted by uid313 View Post
        And it clutters your file system with lots of files in your /bin folder.

        Code:
        $ pg
        pg pg_dumpall pgmnorm pg_recvlogical
        pg_archivecleanup pg_isready pgmoil pg_renamecluster
        pg_basebackup pg_lsclusters pgmramp pgrep
        pgbench pgmbentley pgmslice pg_restore
        pg_config pgmcrater pgmtexture pg_updatedicts
        pg_conftool pgmedge pgmtofs pg_upgradecluster
        pg_createcluster pgmenhance pgmtolispm pg_virtualenv
        pg_ctlcluster pgmhist pgmtopbm
        pg_dropcluster pgmkernel pgmtoppm
        pg_dump pgmnoise pg_receivexlog
        Also not everything is prefixed pg*.
        All that pgm* stuff is not part of Postgres, at least, and while I'm just guessing here, I can imagine those pg_* files to be considered of vital importance (i.e. the reason they should be in /bin) if you are running an important database server.

        Comment


        • #5
          Originally posted by hansg View Post

          All that pgm* stuff is not part of Postgres, at least, and while I'm just guessing here, I can imagine those pg_* files to be considered of vital importance (i.e. the reason they should be in /bin) if you are running an important database server.
          Very vital as it visually makes it quick to get at the commands you need without digging through a bunch of man pages. For a seasoned person I'm sure much of the admin commands are buried in the cranium, but for a junior admin this would be something they'd hope the system had installed.

          Comment


          • #6
            Originally posted by uid313 View Post
            And it clutters your file system with lots of files in your /bin folder.

            Code:
            $ pg
            pg pg_dumpall pgmnorm pg_recvlogical
            pg_archivecleanup pg_isready pgmoil pg_renamecluster
            pg_basebackup pg_lsclusters pgmramp pgrep
            pgbench pgmbentley pgmslice pg_restore
            pg_config pgmcrater pgmtexture pg_updatedicts
            pg_conftool pgmedge pgmtofs pg_upgradecluster
            pg_createcluster pgmenhance pgmtolispm pg_virtualenv
            pg_ctlcluster pgmhist pgmtopbm
            pg_dropcluster pgmkernel pgmtoppm
            pg_dump pgmnoise pg_receivexlog
            Also not everything is prefixed pg*.
            Code:
            $ dpkg -S pgmramp
            netpbm: /usr/share/man/man1/pgmramp.1.gz
            netpbm: /usr/bin/pgmramp
            $ dpkg -S pgmenhance 
            netpbm: /usr/share/man/man1/pgmenhance.1.gz
            netpbm: /usr/bin/pgmenhance
            So, yeah, that's not part of the Postgres package.

            Comment


            • #7
              Originally posted by Marc Driftmeyer View Post

              Very vital as it visually makes it quick to get at the commands you need without digging through a bunch of man pages. For a seasoned person I'm sure much of the admin commands are buried in the cranium, but for a junior admin this would be something they'd hope the system had installed.
              I'm guessing even a junior sysadm knowns how to list the files in a package and even pipe it through grep or to less.

              Comment


              • #8
                apt-file!

                Comment


                • #9
                  Originally posted by uid313 View Post
                  And it clutters your file system with lots of files in your /bin folder.

                  Code:
                  $ pg
                  pg pg_dumpall pgmnorm pg_recvlogical
                  pg_archivecleanup pg_isready pgmoil pg_renamecluster
                  pg_basebackup pg_lsclusters pgmramp pgrep
                  pgbench pgmbentley pgmslice pg_restore
                  pg_config pgmcrater pgmtexture pg_updatedicts
                  pg_conftool pgmedge pgmtofs pg_upgradecluster
                  pg_createcluster pgmenhance pgmtolispm pg_virtualenv
                  pg_ctlcluster pgmhist pgmtopbm
                  pg_dropcluster pgmkernel pgmtoppm
                  pg_dump pgmnoise pg_receivexlog
                  Also not everything is prefixed pg*.
                  But that the UNIX way: small, focused programs that each does one job and it does the job very well

                  Comment


                  • #10
                    Originally posted by bug77 View Post

                    But that the UNIX way: small, focused programs that each does one job and it does the job very well
                    Good point.

                    I am not sure all utilities that come with PostgreSQL are prefixed with the pg_ prefix though.

                    Comment

                    Working...
                    X