| with table_stats as ( | |
| select psut.relname, | |
| psut.n_live_tup, | |
| 1.0 * psut.idx_scan / greatest(1, psut.seq_scan + psut.idx_scan) as index_use_ratio | |
| from pg_stat_user_tables psut | |
| order by psut.n_live_tup desc | |
| ), | |
| table_io as ( | |
| select psiut.relname, | |
| sum(psiut.heap_blks_read) as table_page_read, |
| // Zero-Clause BSD (more permissive than MIT, doesn't require copyright notice) | |
| // | |
| // Permission to use, copy, modify, and/or distribute this software for any purpose | |
| // with or without fee is hereby granted. | |
| // | |
| // THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES | |
| // WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY | |
| // AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT, | |
| // INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS | |
| // OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER |
| public class TestController : ApiController { | |
| //illustrates how to return multipart/mixed content: http://www.w3.org/Protocols/rfc1341/7_2_Multipart.html | |
| private HttpResponseMessage Get() | |
| { | |
| var friend = GetFriend(); | |
| var friendContent = new ObjectContent<Friend>(friend, new JsonMediaTypeFormatter()); | |
| var response = new HttpResponseMessage(); | |
| //create the multipart content and specify the boundary |
| angular.module('myMdl', []).config(['$httpProvider', function($httpProvider) { | |
| $httpProvider.responseInterceptors.push([ | |
| '$q', '$templateCache', 'activeProfile', | |
| function($q, $templateCache, activeProfile) { | |
| // Keep track which HTML templates have already been modified. | |
| var modifiedTemplates = {}; | |
| // Tests if there are any keep/omit attributes. | |
| var HAS_FLAGS_EXP = /data-(keep|omit)/; |
| /** | |
| * Example of using an angular provider to build an api service. | |
| * @author Jeremy Elbourn (@jelbourn) | |
| */ | |
| /** Namespace for the application. */ | |
| var app = {}; | |
| /******************************************************************************/ |
| # verified against log_in.feature for blake | |
| # https://github.com/jnicklas/capybara/issues/1443 | |
| # turn on webkit driver debug | |
| $use_webkit = true | |
| $use_chrome_instead_of_firefox = false | |
| $webkit_debug = false | |
| $wait_time = 5 | |
| def webkit_driver | |
| if $webkit_debug |
| guard 'development-export' do | |
| watch(%r{^vendor/assets/javascripts/.+\.(?:coffee|eco|js)$}) { | |
| [ | |
| 'vendor/assets/javascripts/vendor.coffee', | |
| 'spec/javascripts/spec_helper.coffee' | |
| ] | |
| } | |
| watch(%r{^(?:assets|spec)/javascripts/.+\.(?:coffee|eco|js)$}) | |
| end |
| #!/usr/bin/env ruby | |
| # == Simple Daemon | |
| # | |
| # A simple ruby daemon that you copy and change as needed. | |
| # | |
| # === How does it work? | |
| # | |
| # All this program does is fork the current process (creates a copy of | |
| # itself) then exits, the fork (child process) then goes on to run your | |
| # daemon code. In this example we are just running a while loop with a |
This installs a patched ruby 1.9.3-p327 with various performance improvements and a backported COW-friendly GC, all courtesy of funny-falcon.
You will also need a C Compiler. If you're on Linux, you probably already have one or know how to install one. On OS X, you should install XCode, and brew install autoconf using homebrew.
| # rbenv | |
| export PATH="$HOME/.rbenv/bin:$PATH" | |
| eval "$(rbenv init -)" | |
| source ~/.rbenv/completions/rbenv.bash | |
| # prompt with ruby version | |
| # rbenv version | sed -e 's/ .*//' | |
| __rbenv_ps1 () | |
| { | |
| rbenv_ruby_version=`rbenv version | sed -e 's/ .*//'` |
