Pivotal Knowledge Base

Follow

Incremental backup state files for HEAP tables

Environment

Product Version
Pivotal Greenplum (GPDB) 4.3.x
OS All OS
Others  

Symptom

When performing an incremental backup using gpcrondump utility, can we only just backup just the changes for HEAP tables instead of the entire table?

Cause   

Per the current design of gpcrondump, when an incremental backup is ran, state files are not generated for HEAP tables since they get backed up with every incremental backup. Currently, the gpcrondump utility only compares the state of each table in the database against the last backup using state files. If there are any change in the state of the table since last backup, it is marked dirty and is backed up during incremental backup. This procedure currently is followed only for AO/CO tables.

Resolution

A new feature request was submitted to Pivotal Greenplum Engineering team to ask for state files for HEAP tables.

 

Related Articles 

FAQ: Bloat in HEAP tables

GPDB External Table Error Handling

Comments

Powered by Zendesk