Search code examples
postgresqlcitus

CitusDB append distribution on non-numeric column

I am reading the CitusDB documentation here: https://docs.citusdata.com/en/v6.1/reference/append.html and I understand the mechanics of how append distribution works. However, I would like to know if the append distribution would work on non-numeric columns too. For example: 

create_distributed_table('distributed_table', 'non_numeric_col', 'append');

where the non_numeric_col could have values in the form of alphabet_number "A_61", "B_355" etc.,

Solution

  • It works, assuming you are going to use TEXT datatype for your partition column. Technically, Citus append partitioning method works with column types having min() and max() functions defined.