Move database tables with screenshots to a new hard disk

Recording Service performance may vary depending on the hardware configuration. If you intend to use more than 20 Recorder instances, store PostgreSQL databases partially or fully on the SSD for better performance.

Only database tables containing screenshots can be moved to a new hard disk.

You can do this once the Recording Service installation or upgrade is complete as follows:

1. Create a folder on HDD, for example, D:\PostgresData.

2. Provide full access to this folder to the account used to run the PostgreSQL service.

   The default account is NT AUTHORITY\NetworkService

3. Perform the following actions on your PostgreSQL instance as superuser:

   1. Register a new tablespace to define an alternative location on the file system where the data files containing database tables and indexes will reside.

      To do this, run the command CREATE TABLESPACE tablespace_name LOCATION 'directory';

      Example: CREATE TABLESPACE slow_large_disk LOCATION 'D:\PostgresData';

      Skip this step if you are registering a new tablespace for Recording Service 1.1 screenshots.

   2. Change the tablespace of the screenshot table to the specified tablespace and move the data file(s) associated with the table to the new tablespace.

      To do this, run the command ALTER TABLE "Screenshot" SET TABLESPACE new_tablespace

      Example: ALTER TABLE "Screenshot" SET TABLESPACE slow_large_disk;

      Do not move the data files for any other tables.