tuhaihe commented on code in PR #289: URL: https://github.com/apache/cloudberry-site/pull/289#discussion_r2149521299
########## docs/operate-with-data/pax-table-format.md: ########## @@ -468,7 +468,6 @@ By following the steps above, you can track and analyze WAL logs related to PAX - Currently, if a field is too long, it will be stored in a TOAST file. This TOAST is different from PostgreSQL's TOAST tables, and they only share the same name. - Unlike traditional heap tables, PAX format does not support `TOAST` fields. Currently, all column data is stored in the same data file. - The PAX format does not support data backup and restore using `pg_dump` or `pg_restore`. PAX tables are ignored during these operations. -- PAX format does not support Write-Ahead Logging (WAL), so there is no data backup between the primary and mirror servers. Review Comment: 1. PAX supports WAL - so can we add this to the feature list or somewhere for a note? 2. > For `The PAX format does not support data backup and restore using `pg_dump` or `pg_restore`. PAX tables are ignored during these operations.` After confirmation with the engineer, now PAX does not support data backup and restore using `pg_dump`, but can use `pg_basebackup` to back up and restore data. We can improve this line too. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@cloudberry.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cloudberry.apache.org For additional commands, e-mail: commits-h...@cloudberry.apache.org
