database performance - test setup

database performance: test setup: PostgreSQL

Postgres has been bundled with most open-source operating system for many years so it is no surprise that the installation was remarkably easy:

yum install postgresql postgresql-server
chkconfig postgresql on
/etc/init.d/postgresql start
echo "CREATE USER test with PASSWORD 'test'; \
 GRANT ALL ON DATABASE test to test;" \
 | psql -U postgres template1

This is all that is needed to access the database with the following JDBC url:
jdbc:postgresql://localhost:5432/test
The default connections will use isolation level 2: "Read Committed".