The POM database can reside either on, Oracle Enterprise Edition 64 bit, PostgreSQL, or Microsoft SQL Server Standard/Enterprise Edition database. To create the POM database schema on the respective database, create blank database instances.

For information about creating a PostgreSQL user, go to http://www.postgres.org. You must get the CREATE privilege on the database.

For information about creating an Oracle database user, go to http://www.oracle.com. You must get the CREATE SEQUENCE, CREATE SESSION, CREATE TABLE, and CREATE VIEW privileges. See Requirements for database login.

For information about creating a Microsoft SQL Server database user, go to http://technet.microsoft.com/en-us/library/aa337545. Ensure you set the READ_COMMITTED_SNAPSHOT database parameter ON.

Database name	Server type
PostgreSQL	An external server
Oracle	An external server Note: Install the Oracle JDBC driver. For more information, see Installing an Oracle driver.
Microsoft SQL Server	An external server

For more information about database configurations, see Different configurations for the database.

Best practices for using PostgreSQL database parameters

On a server of 32GB of RAM, the following memory parameters are a baseline:

Parameter	Value
shared_buffers	6 GB (you can increase this value)
effective_cache_size	12 GB (you can increase this value)
maintenance_work_mem	1 GB
work_mem	8 MB
max_parallel_maintenance_workers	4
checkpoint_completion_target	0.9
wal_buffers	16MB
max_worker_processes	10
max_parallel_workers_per_gather	4
max_parallel_workers	10

If more RAM is available on the server, use the following:

Parameter	Value
shared_buffer	25% of the total RAM of your machine
effective_cache_size	50% or 75% of the total RAM of your machine

To use the autovacuum feature in PostgreSQL, enable the following parameters:

Parameter	Value
autovacuum	on
track_counts	on
autovacuum_vacuum_scale_factor	0.1 (The default value is 0.2)

Set the autovacuum_vacuum_scale_factor parameter to run on autovacuum if the POM database generates dead tuples more than 10% of the total rows in its table.