Running Queries 1549 Additional Information 1550 About the Updatability Option 1550 About the Cost Estimation Options 1550 About Connection Management 1550 About Transaction Management 1550 Known Issues Documentation VMware, Inc. 102 Memory Consumption Parameters 1567 OS Resource Parameters 1567 Cost-Based Vacuum Delay Parameters 1567 Transaction ID Management Parameters 1568 GPORCA Parameters 1568 rval 1578 client_encoding 1579 client_min_messages 1579 cpu_index_tuple_cost 1579 cpu_operator_cost 1580 cpu_tuple_cost 1580 cursor_tuple_fraction 1580 data_checksums 1580 DateStyle 1581 db_user_namespace

Running Queries 1839 Additional Information 1840 About the Updatability Option 1840 About the Cost Estimation Options 1840 About Connection Management 1840 About Transaction Management 1840 About Using Resource Consumption Parameters 1874 Memory Consumption Parameters 1874 OS Resource Parameters 1875 Cost-Based Vacuum Delay Parameters 1875 Transaction ID Management Parameters 1875 Other Parameters 1875 rval 1889 client_encoding 1889 client_min_messages 1889 cpu_index_tuple_cost 1889 cpu_operator_cost 1890 cpu_tuple_cost 1890 cursor_tuple_fraction 1890 data_checksums 1890 DateStyle 1891 VMware

Running Queries 1808 Additional Information 1808 About the Updatability Option 1808 About the Cost Estimation Options 1808 About Connection Management 1809 About Transaction Management 1809 Known Issues Resource Consumption Parameters 1840 Memory Consumption Parameters 1840 OS Resource Parameters 1841 Cost-Based Vacuum Delay Parameters 1841 Transaction ID Management Parameters 1841 Other Parameters 1841 rval 1854 client_encoding 1854 client_min_messages 1855 cpu_index_tuple_cost 1855 cpu_operator_cost 1855 cpu_tuple_cost 1855 cursor_tuple_fraction 1856 data_checksums 1856 DateStyle 1856 VMware

Running Queries 1799 Additional Information 1799 About the Updatability Option 1799 About the Cost Estimation Options 1799 About Connection Management 1799 About Transaction Management 1800 About Using Resource Consumption Parameters 1834 Memory Consumption Parameters 1834 OS Resource Parameters 1834 Cost-Based Vacuum Delay Parameters 1834 Transaction ID Management Parameters 1835 Other Parameters 1835 rval 1848 client_encoding 1848 client_min_messages 1848 cpu_index_tuple_cost 1849 cpu_operator_cost 1849 cpu_tuple_cost 1849 cursor_tuple_fraction 1849 data_checksums 1850 DateStyle 1850 db_user_namespace

Running Queries 1759 Additional Information 1759 About the Updatability Option 1759 About the Cost Estimation Options 1759 About Connection Management 1760 About Transaction Management 1760 Known Issues Resource Consumption Parameters 1781 Memory Consumption Parameters 1781 OS Resource Parameters 1781 Cost-Based Vacuum Delay Parameters 1782 Transaction ID Management Parameters 1782 Other Parameters 1782 rval 1795 client_encoding 1795 client_min_messages 1795 cpu_index_tuple_cost 1796 cpu_operator_cost 1796 cpu_tuple_cost 1796 cursor_tuple_fraction 1796 data_checksums 1796 DateStyle 1797 db_user_namespace

Running Queries 1753 Additional Information 1753 About the Updatability Option 1753 About the Cost Estimation Options 1753 About Connection Management 1753 About Transaction Management 1754 Known Issues Resource Consumption Parameters 1773 Memory Consumption Parameters 1773 OS Resource Parameters 1773 Cost-Based Vacuum Delay Parameters 1773 Transaction ID Management Parameters 1774 GPORCA Parameters 1774 rval 1787 client_encoding 1787 client_min_messages 1787 cpu_index_tuple_cost 1788 cpu_operator_cost 1788 cpu_tuple_cost 1788 cursor_tuple_fraction 1788 data_checksums 1788 DateStyle 1789 db_user_namespace

Running Queries 1549 Additional Information 1550 About the Updatability Option 1550 About the Cost Estimation Options 1550 About Connection Management 1550 About Transaction Management 1550 Known Issues Resource Consumption Parameters 1565 Memory Consumption Parameters 1565 OS Resource Parameters 1566 Cost-Based Vacuum Delay Parameters 1566 Transaction ID Management Parameters 1566 GPORCA Parameters 1566 rval 1578 client_encoding 1578 client_min_messages 1578 cpu_index_tuple_cost 1578 cpu_operator_cost 1579 cpu_tuple_cost 1579 cursor_tuple_fraction 1579 data_checksums 1579 DateStyle 1579 db_user_namespace

Resource Consumption Parameters 1555 Memory Consumption Parameters 1555 OS Resource Parameters 1555 Cost-Based Vacuum Delay Parameters 1555 Transaction ID Management Parameters 1556 GPORCA Parameters 1556 check_function_bodies 1566 client_encoding 1566 client_min_messages 1567 cpu_index_tuple_cost 1567 cpu_operator_cost 1567 cpu_tuple_cost 1568 cursor_tuple_fraction 1568 data_checksums 1568 DateStyle 1569 db_user_namespace gp_max_local_distributed_cache 1601 gp_max_packet_size 1601 gp_max_plan_size 1601 gp_max_slices 1602 gp_motion_cost_per_row 1602 gp_recursive_cte 1602 gp_reject_percent_threshold 1603 gp_reraise_signal 1603 gp

Resource Consumption Parameters 1546 Memory Consumption Parameters 1546 OS Resource Parameters 1546 Cost-Based Vacuum Delay Parameters 1546 Transaction ID Management Parameters 1547 GPORCA Parameters 1547 check_function_bodies 1557 client_encoding 1557 client_min_messages 1558 cpu_index_tuple_cost 1558 cpu_operator_cost 1558 cpu_tuple_cost 1558 cursor_tuple_fraction 1559 data_checksums 1559 DateStyle 1559 db_user_namespace gp_max_local_distributed_cache 1590 gp_max_packet_size 1591 gp_max_plan_size 1591 gp_max_slices 1591 gp_motion_cost_per_row 1592 gp_recursive_cte 1592 gp_reject_percent_threshold 1592 gp_reraise_signal 1593 gp

SSD, NVM ■ Stable stage 稳定存储器 theoretically never cannot be guaranteed 图片来源: Power consumption estimation using in-memory database computation 10 不同存储介质的访问时间 图片来源：Systems Performance: Enterprise and Data files Log files Log Buffer Pool Log record … Log buffer Random Access Cost: ~15ms Sequential Access Cost: ~1ms append 18 1. All log records pertaining to an updated page are written to