Top
Enterprise Postgres 18 for Kubernetes User's Guide

5.14.3 Schedule for Fixed Statistics

Define the object storage information and schedule where the statistics are stored in the FEPCluster custom resource in the production environment. You can also add, modify, or delete schedules after they are built.

The following is an example of the FEPCluster custom resource definition for each Friday from 20:00 to 23:00 when the database "mydatabase" is pinned with statistics stored in object storage AWS s3.

Example) Definition example of FEPCluster custom resource

spec:
  fep:
    fixedStats: 
      schedule1: 
        update: true
        fixSchedule: "0 20 * * 5" 
        unfixSchedule: "0 23 * * 5" 
        targetDb: mydatabase 
        url: 's3://export_stats/file '
      endpoint: 
        protocol: s3
        authentication: my-aws-s3-secret

Once the statistics are downloaded from object storage, they are backed up to the database. Also, spec.fep.fixedStats.schedleN.update will be from true to false.

If you want to update the statistics that you want to freeze, change spec.fep.fixedStats.schedleN.update to ture and run the statistics import from object storage again.