Tablespaces

With the help of Postgres tablespaces, the physical storage location (hard disk) of database tables is determined.

With the SKR3 installation the following tablespaces are currently generated.

• Stoll PPS:
• skr_primary for the primary SKR database
• skr_secondary for the secondary evaluation(s)
• pps_primary for PPS
• skr_ramdisk - obsolete
  was used for performance tests
• Postgres system:
• pg_default
  Postgres default
• pg_global
  Postgres system catalog

Optimum performance (load distribution) is achieved, if an individual SSD is available for:

• skr_primary
• skr_secondary
• pps_primary
• pg_default and pg_global in common
• Windows

(a total of 5 SSD)
Performance and Scaling

When creating new tables, it is possible to specify in Postgres, which tablespace is to be used.
Otherwise, the default tablespace of the user signed-in will be used.