GitHub user jianlirong added a comment to the discussion: PAX Storage: Questions for PAX developers
@edespino , thank you very much for your efforts. This is truly outstanding work. However, I would like to offer a suggestion, considering one of your points about AO tables mentioned above. The tests above focus on query scenarios. I suggest adding test scenarios for data loading, updates, and deletion operations. Based on feedback from some customers, they face a dilemma when choosing between AO tables and AOCS tables: For scenarios requiring high-speed data ingestion (not bulk one-time loading, but continuous batch loading, such as loading once per second with 100,000 records each time), like in telecommunications or IoT, if they choose AOCS tables, the ingestion speed cannot keep up with the data generation rate, but it can meet subsequent query performance requirements; if they choose AO tables, the ingestion speed can be satisfied, but the subsequent query performance is relatively poor. According to previous community discussions, in addition to the PAX advantages you mentione d, another very important design goal of PAX tables is to achieve the ingestion speed of AO tables and the query speed of AOCS tables. GitHub link: https://github.com/apache/cloudberry/discussions/1421#discussioncomment-14825494 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
