PostgreSQL benchmark

database.sql

CREATE TABLE test (
  id   serial NOT NULL primary key,
  name text
  desc1 text
  desc2 text
);
CREATE INDEX alll ON test(name, desc1, desc2);
CREATE INDEX name ON test(name);
CREATE INDEX more ON test(name, desc1);
CREATE INDEX more1 ON test(name, desc2);

pg_benchmark.rb

require 'pg'

conn = PG.connect( dbname: 'benchmark' )
(1...10000).each do
  conn.exec( "INSERT INTO test(name) VALUES('t')" ) do |result|
  end
end