Forum Replies Created

  • nugend

    Member
    April 27, 2022 at 12:00 am in reply to: Size of message received by .z.pg/.z.ps

    Ah, nm. Thought about it a bit more and realized Q would just be running -22! to do a count since the on-the-wire size would be compressed anyway.

  • Be aware that the p attribute is not directly correlated with whether a table is partitioned or not. A table being partitioned refers to the fact that it stored inside multiple partition directories within the database. A column having the p attribute means that the data in the column is ordered in contiguous, unique blocks.

    You will at least have to update the columns with the p attribute manually and you may have to re-sort the data in each of the partitions for the table.