Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Commits on Apr 24, 2012
  1. Optimize job queries with proper indexing.

    authored
    In merge with pull request #59 primary key index definition on jobs table was dropped causing serious performance regression. This commit adds it back.
    
    Another index is added to optimize query that polls unlocked jobs from a named queue. It is done by adding a composite index on (q_name, id) columns that yields simple index scan for this query. Since we use pg we can restrict only to columns that are not locked using a partial index making this query even faster and index smaller (especially for queues with many workers/locked jobs).
    
      Here are benchmark results using 2 runs on benchmark.rb file.
    
      Baseline:
    
             user     system      total        real
      5 workers  6.310000   1.150000   7.460000 ( 82.541974)
      5 workers  5.900000   0.840000   6.740000 ( 76.178325)
    
      With primary key:
             user     system      total        real
      5 workers  5.960000   0.910000   6.870000 ( 34.021094)
      5 workers  6.080000   1.010000   7.090000 ( 34.210940)
    
      With partial composite key:
             user     system      total        real
      5 workers  5.590000   0.910000   6.500000 ( 31.838356)
      5 workers  5.470000   0.910000   6.380000 ( 31.238608)
    
    The difference between the latter two is quite small since benchmark.rb does use only one (default) queue which makes the composite key poorly selective. However the more named queues you have the more you should benefit from this optimization.
Commits on Apr 20, 2012
  1. Merge pull request #59 from csquared/create_table_function

    ♠ ace hacker authored
    one-command db-setup
Commits on Apr 16, 2012
  1. @csquared
Commits on Apr 12, 2012
  1. use scrolls, the gem, instad of the file

    Ryan Smith (ace hacker) authored
Commits on Apr 11, 2012
  1. update readme with latest version

    Ryan Smith (ace hacker) authored
  2. version bump 2.0.0rc11

    Ryan Smith (ace hacker) authored
  3. Merge branch 'master' of github.com:ryandotsmith/queue_classic

    Ryan Smith (ace hacker) authored
  4. Merge pull request #56 from glenngillen/master

    ♠ ace hacker authored
    Lazy evaluate database URL
  5. @glenngillen
Commits on Apr 8, 2012
  1. version bump

    Ryan Smith (ace hacker) authored
  2. consisten quotes

    Ryan Smith (ace hacker) authored
  3. Log data.

    Ryan Smith (ace hacker) authored
    Provide a mechanism for QC users to handle log events.
    See instruments for an example usage: https://gist.github.com/2317855.
    This change also provided an opportunity to use structured data as the
    log format..
Commits on Apr 7, 2012
  1. whitespace

    Ryan Smith (ace hacker) authored
Commits on Mar 28, 2012
  1. Merge pull request #54 from pcantrell/master

    Ryan Smith (ace hacker) authored
    Better argument structure for QC::Worker.new
  2. @pcantrell

    Changed Worker.new to accept an options hash (with all values optiona…

    pcantrell authored
    …l), or no args at all (to make everything default).
Commits on Mar 27, 2012
  1. version bump

    Ryan Smith (ace hacker) authored
  2. fix attempt calc

    Ryan Smith (ace hacker) authored
  3. fix off by one error

    Ryan Smith (ace hacker) authored
  4. bump v2.0.0rc6 fix quoting problems

    Ryan Smith (ace hacker) authored
  5. 2.0.0rc5 version bump. fix listen/notify

    Ryan Smith (ace hacker) authored
  6. Merge branch 'master' of github.com:ryandotsmith/queue_classic

    Ryan Smith (ace hacker) authored
  7. tell the conn what chan to work on

    Ryan Smith (ace hacker) authored
  8. Merge pull request #52 from pcantrell/patch-1

    Ryan Smith (ace hacker) authored
    Apostrophe fix
Commits on Mar 26, 2012
  1. @pcantrell
Commits on Mar 20, 2012
  1. Merge pull request #50 from rubysolo/patch-1

    Ryan Smith (ace hacker) authored
    Fix type in readme for AR setup
  2. Merge pull request #51 from gonz/patch-1

    Ryan Smith (ace hacker) authored
    Remove reference to table name. queue_classic uses only one table now...
  3. @gonz
Commits on Mar 19, 2012
  1. @rubysolo
  2. Merge pull request #48 from hgillane/master

    Ryan Smith (ace hacker) authored
    ensure rake task for drop_functions actually drops the functions
Commits on Mar 18, 2012
  1. @hgillane

    rename duplicate rake task

    hgillane authored
  2. Ensure the gem has access to sql files.

    Ryan Smith authored
    Bumping to rc4
  3. Move sql functions to project's root dir

    Ryan Smith authored
    Fixes #47
Commits on Mar 17, 2012
  1. correct typos in readme

    Ryan R. Smith (ace hacker) authored
  2. correct link

    Ryan R. Smith (ace hacker) authored
Something went wrong with that request. Please try again.