semaperepelitsa

create extension if not exists hstore;

create table if not exists test_array  as
  select id, '{"A","B","C"}'::varchar[] || id::varchar as codes from generate_series(1, 100000) id;
create table if not exists test_hstore as
  select id, '"A"=>t,"B"=>t,"C"=>t'::hstore || hstore(id::varchar, 't') as codes from generate_series(1, 100000) id;
create table if not exists test_jsonb  as
  select id, '{"A":true,"B":true,"C":true}'::jsonb || jsonb_build_object(id::varchar, true) as codes from generate_series(1, 100000) id;

\timing on

dchest

Don't write in C.

amateurhuman

Installing rbx-2.0.0-dev with Ruby 1.9 support using rbenv can be a tad tricky. This is what I did to get up and running, you'll need another version of ruby already installed as well as rake.

The basic outline:

1. Clone Rubinius HEAD from github
2. Configure installation for rbenv and 1.9 support
3. Install Rubinius
4. Configure your $PATH to use Rubinius gems
5. Start using Rubinius

vlado

# ** ERROR 1 **
# FATAL:  lock file "postmaster.pid" already exists
# HINT:  Is another postmaster (PID 4646) running in data directory "/usr/local/var/postgres"?
#
# ** ERROR 2 **
# Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
#
# To fix one of this errors:

cat /usr/local/var/postgres/postmaster.pid # pid is the number on first line

sstephenson

# RubyGems has this functionality built-in. Just specify
# the particular version you want to use as the first argument
# of the command, surrounded by underscores.

$ gem install rails --version 3.0.9
...
$ gem install rails --pre
...
$ rbenv rehash
$ rails --version