database performance - test setup

database performance: test setup: Solaris

When this report was being written the latest release of Solaris available was Solaris 12/2006.

Installation

Using the GUI installer, we select the smallest set of packages with Java.

Next, we install the database servers:

groupadd postgres 
useradd -c 'PostgreSQL user' -d /export/home/postgres -g postgres -m -s /bin/bash postgres
chown postgres /var/lib/pgsql/data 
chmod 700 /var/lib/pgsql/data
	And as postgres, do this:
initdb -D /var/lib/pgsql/data
pg_ctl -D /var/lib/pgsql/data -l postmaster.log start

OutOfMemory

The tests kept throwing exceptions with more than 500 threads on Solaris, which means that a lot of the data is simply missing for Solaris:

unable to create new native thread
 
 java.lang.OutOfMemoryError: unable to create new native thread
 at java.lang.Thread.start0(Native Method)
 at java.lang.Thread.start(Thread.java:597)
 at com.metastores.system.database.performance.AbstractThreadedCombinedTest.testConcurrentCombined(Unknown Source)
 at com.metastores.system.database.performance.ThreadedCombinedTest.testConcurrentFewThreads(Unknown Source)