Skip to content

Fork of sortbenchmark.org "gensort" tool for benchmarking PostgreSQL sort performance

Notifications You must be signed in to change notification settings

petergeoghegan/gensort

Repository files navigation

Gensort and Valsort Source Code Distribution

What's New in Version 1.5?
----------------------------
- The "-s" option has been added to the gensort program. This option causes
  moderately skewed input keys to be generated.
- The valsort program is unchanged, except its version number is now 1.5.

Contents
--------
  Source code and associated include files:
      gensort.c
      valsort.c
      sump.c
      sump.h 
      sump_win.c    (necessary only on Windows)
      sump_win.h    (necessary only on Windows)
      sumpversion.h
      rand16.c
      rand16.h

   Makefile and supporting files:
      Makefile
      Make.win

   GNU GPL 2.0 License
      gpl-2.0.txt

   Zlib files:      (necessary only on Windows)
      zdll.lib
      zlib1.dll
      zlib/include/zlib.h
      zlib/include/zconf.h

Directions
----------
   On Linux:
      To build gensort and valsort:
         make

   On Windows 
      To build gensort and valsort:
      (For nmake commands, must be inside an x86 Visual Studio Command 
      Prompt window.)
         nmake -f Make.win
      If you move gensort.exe or valsort.exe to a different directory,
      you need to make sure the zlib1.dll file is either in the same
      directory or in a directory Windows will search for x86 dll's.

Creating PostgreSQL table on Linux
----------------------------------

Run Python tool:

./postgres_load.py

Note that the number of worker threads is configurable (see --help).  The tool
currently always uses "Daytona Sort" style ascii keys.

The wrapper script supports creating a table with skew, to moderately decrease
the effectiveness of abbreviated keys.  By default, 100 million tuples are
created.  Currently, the size of the resulting PostgreSQL table is 6512 MB with
that default.

Note that all tables are loaded with COPY FREEZE, to maximize inter-run
determinism for performance testing optimizations to sorting.

About

Fork of sortbenchmark.org "gensort" tool for benchmarking PostgreSQL sort performance

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages