build postgres install postgres cd $pg_src/contrib/pgbench make install initdb $PG_DATA (eg /var/database) configure postgres (config follows) pg_ctl -D $PG_DATA start createdb pgbench pgbench -i pgbench (creates the pgbench data) pgbench -c 2 -t 16384 # kablooie __POSTGRES CONFIG__ port = 5432 tcpip_socket = true hostname_lookup = false show_source_port = false ssl = false max_connections = 4 shared_buffers = 98304 sort_mem = 16384 vacuum_mem = 8192 commit_delay = 10000 commit_siblings = 64 cpu_operator_cost = 0.1 cpu_tuple_cost = 0.002 fsync = false wal_buffers = 2048 max_fsm_pages = 1000000 max_fsm_relations = 1000 max_locks_per_transaction = 64 stats_block_level = true stats_command_string = false stats_reset_on_server_start = true stats_row_level = true stats_start_collector = true superuser_reserved_connections = 8