开源项目 > 其他开源 > 图书/手册/教程 &&

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

最佳实践-20.md 7.81 KB

# 最佳实践<a name="ZH-CN_TOPIC_0289900010"></a>

相关参数解释参考表[GS\_OPT\_MODEL](zh-cn_topic_0289900860.md)。

**表 1**

<a name="zh-cn_topic_0283137459_table1634913802611"></a>
<table><thead align="left"><tr id="zh-cn_topic_0283137459_row193491938102617"><th class="cellrowborder" valign="top" width="50%" id="mcps1.2.3.1.1"><p id="zh-cn_topic_0283137459_p1134913822618"><a name="zh-cn_topic_0283137459_p1134913822618"></a><a name="zh-cn_topic_0283137459_p1134913822618"></a>模型参数</p>
</th>
<th class="cellrowborder" valign="top" width="50%" id="mcps1.2.3.1.2"><p id="zh-cn_topic_0283137459_p193491538172612"><a name="zh-cn_topic_0283137459_p193491538172612"></a><a name="zh-cn_topic_0283137459_p193491538172612"></a>参数建议</p>
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0283137459_row163502389264"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p03501381269"><a name="zh-cn_topic_0283137459_p03501381269"></a><a name="zh-cn_topic_0283137459_p03501381269"></a>template_name</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p1671224843918"><a name="zh-cn_topic_0283137459_p1671224843918"></a><a name="zh-cn_topic_0283137459_p1671224843918"></a>‘rlstm’</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row1635073872610"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p1735063872614"><a name="zh-cn_topic_0283137459_p1735063872614"></a><a name="zh-cn_topic_0283137459_p1735063872614"></a>model_name</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p93501338152612"><a name="zh-cn_topic_0283137459_p93501338152612"></a><a name="zh-cn_topic_0283137459_p93501338152612"></a>自定义，如‘open_ai’，需满足unique约束。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row6350113832613"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p3350938152610"><a name="zh-cn_topic_0283137459_p3350938152610"></a><a name="zh-cn_topic_0283137459_p3350938152610"></a>datname</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p20350338182615"><a name="zh-cn_topic_0283137459_p20350338182615"></a><a name="zh-cn_topic_0283137459_p20350338182615"></a>所服务database名称，如‘postgres’。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row1435023812619"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p4350103802619"><a name="zh-cn_topic_0283137459_p4350103802619"></a><a name="zh-cn_topic_0283137459_p4350103802619"></a>ip</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p1735083814263"><a name="zh-cn_topic_0283137459_p1735083814263"></a><a name="zh-cn_topic_0283137459_p1735083814263"></a>aiEngine-ip地址，如‘127.0.0.1’。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row10350103815267"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p135033882611"><a name="zh-cn_topic_0283137459_p135033882611"></a><a name="zh-cn_topic_0283137459_p135033882611"></a>port</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p15350103814261"><a name="zh-cn_topic_0283137459_p15350103814261"></a><a name="zh-cn_topic_0283137459_p15350103814261"></a>aiEngine监听端口，如‘5000’。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row1350113813269"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p15350123817268"><a name="zh-cn_topic_0283137459_p15350123817268"></a><a name="zh-cn_topic_0283137459_p15350123817268"></a>max_epoch</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p7350193816262"><a name="zh-cn_topic_0283137459_p7350193816262"></a><a name="zh-cn_topic_0283137459_p7350193816262"></a>迭代次数，推荐较大数值，保证收敛效果，如‘2000’。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row1350938132618"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p1351113812263"><a name="zh-cn_topic_0283137459_p1351113812263"></a><a name="zh-cn_topic_0283137459_p1351113812263"></a>learning_rate</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p212637174717"><a name="zh-cn_topic_0283137459_p212637174717"></a><a name="zh-cn_topic_0283137459_p212637174717"></a>(0, 1]浮点数，推荐较大的学习率，助于加快收敛速度。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row1598817574474"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p798905720473"><a name="zh-cn_topic_0283137459_p798905720473"></a><a name="zh-cn_topic_0283137459_p798905720473"></a>dim_red</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p189898571472"><a name="zh-cn_topic_0283137459_p189898571472"></a><a name="zh-cn_topic_0283137459_p189898571472"></a>特征值降维系数：</p>
<p id="zh-cn_topic_0283137459_p152371522184916"><a name="zh-cn_topic_0283137459_p152371522184916"></a><a name="zh-cn_topic_0283137459_p152371522184916"></a>‘-1’：不采用PCA降维，全量特征；</p>
<p id="zh-cn_topic_0283137459_p6296124710492"><a name="zh-cn_topic_0283137459_p6296124710492"></a><a name="zh-cn_topic_0283137459_p6296124710492"></a>‘（0，1] ’区间浮点数：越小，训练维度越小，收敛速度越快，但影响训练准确率。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row15391601486"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p1839180194815"><a name="zh-cn_topic_0283137459_p1839180194815"></a><a name="zh-cn_topic_0283137459_p1839180194815"></a>hidden_units</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p339130184818"><a name="zh-cn_topic_0283137459_p339130184818"></a><a name="zh-cn_topic_0283137459_p339130184818"></a>特征值维度较高时，建议适度增大此参数，提高模型复杂度，如 ‘64，128……’</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row177211488"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p77626489"><a name="zh-cn_topic_0283137459_p77626489"></a><a name="zh-cn_topic_0283137459_p77626489"></a>batch_size</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p6792124818"><a name="zh-cn_topic_0283137459_p6792124818"></a><a name="zh-cn_topic_0283137459_p6792124818"></a>根据编码数据量，较大数据量推荐适度增大此参数，加快模型收敛，如‘256，512……’</p>
</td>
</tr>
<tr id="zh-cn_topic_0283137459_row5476115635612"><td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.1 "><p id="zh-cn_topic_0283137459_p247619569569"><a name="zh-cn_topic_0283137459_p247619569569"></a><a name="zh-cn_topic_0283137459_p247619569569"></a>其他参数</p>
</td>
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.2.3.1.2 "><p id="zh-cn_topic_0283137459_p74765566564"><a name="zh-cn_topic_0283137459_p74765566564"></a><a name="zh-cn_topic_0283137459_p74765566564"></a>参考表<a href="zh-cn_topic_0289900860.md">GS_OPT_MODEL</a></p>
</td>
</tr>
</tbody>
</table>

推荐参数配置：

```
INSERT INTO gs_opt_model values('rlstm', 'open_ai', 'postgres', '127.0.0.1', 5000, 2000，1, -1, 64, 512, 0 , false, false, '{S, T}', '{0,0}', '{0,0}', 'Text');
```

一键复制编辑原始数据按行查看历史

提交于 2020-12-28 09:57 . AI

最佳实践

相关参数解释参考表GS_OPT_MODEL。

表 1

模型参数	参数建议
template_name	‘rlstm’
model_name	自定义，如‘open_ai’，需满足unique约束。
datname	所服务database名称，如‘postgres’。
ip	aiEngine-ip地址，如‘127.0.0.1’。
port	aiEngine监听端口，如‘5000’。
max_epoch	迭代次数，推荐较大数值，保证收敛效果，如‘2000’。
learning_rate	(0, 1]浮点数，推荐较大的学习率，助于加快收敛速度。
dim_red	特征值降维系数： ‘-1’：不采用PCA降维，全量特征； ‘（0，1] ’区间浮点数：越小，训练维度越小，收敛速度越快，但影响训练准确率。
hidden_units	特征值维度较高时，建议适度增大此参数，提高模型复杂度，如 ‘64，128……’
batch_size	根据编码数据量，较大数据量推荐适度增大此参数，加快模型收敛，如‘256，512……’
其他参数	参考表GS_OPT_MODEL

推荐参数配置：

INSERT INTO gs_opt_model values('rlstm', 'open_ai', 'postgres', '127.0.0.1', 5000, 2000，1, -1, 64, 512, 0 , false, false, '{S, T}', '{0,0}', '{0,0}', 'Text');

1

https://gitee.com/opengauss/docs.git

git@gitee.com:opengauss/docs.git

opengauss

docs

docs

2.0.0