Preparations Before Using Iceberg

Setting GUC

In this version, the GUC parameter enable_meta_scan is added to optimize the query performance.

This parameter is enabled by default. However, if the table data volume is small, the query performance may be higher when this parameter is disabled than when it is enabled. Enable or disable this parameter based on site requirements.

Sample code:

1
2
3
4
5
6

SHOW enable_meta_scan;
SET enable_meta_scan=off;
SET enable_meta_scan=on;
or
SET enable_meta_scan=true;
SET enable_meta_scan=false;