agens-graph - 如何提高 AgensGraph 的性能?
问题描述
我的项目进入测试阶段。
但是当大型数据集超过 GigaBytes 时,我遇到了性能不足的问题。
AgensGraph 上是否有可转参数?
解决方案
首先,您可以在“initdb”消息中找到安装目录。
$ initdb
The files belonging to this database system will be owned by user "agens".
This user must also own the server process.
The database cluster will be initialized with locale "ko_KR.UTF-8".
The default database encoding has accordingly been set to "UTF8".
initdb: could not find suitable text search configuration for locale "ko_KR.UTF-8"
The default text search configuration will be set to "simple".
Data page checksums are disabled.
creating directory /Users/agens/Downloads/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
ag_ctl -D /Users/agens/Downloads/pgsql/data -l logfile start
其次,将当前目录更改为代理数据目录。
$ cd /Users/agens/Downloads/pgsql/data
最后,您可以在配置文件中找到缓冲区大小参数。
$ grep shared_buffer postgresql.conf
shared_buffers = 128MB # min 128kB
#wal_buffers = -1 # min 32kB, -1 sets based on shared_buffers
“shared_buffers”参数是搜索性能的关键因素。
建议的缓冲区大小是整个数据的最小值和系统内存的一半。
推荐阅读
- highcharts - xAxis标签上的Highcharts renderer.rect没有响应
- python-3.x - 包括第 3 方共享库以及我的共享库?
- css - 如何将“屏幕”混合模式添加到画布元素?
- node.js - 如何使用sails.js 中的新控制器操作格式上传文件
- android - Flutter Doctor - Android studion 无法识别
- sql - 将全新的列添加到现有表
- python - 从嵌套字典中删除键和值?
- json - 将输出表转换为 JSON
- sql - 如何获得一个工资等级中员工的总和
- hyperledger-fabric - Hyperledger Cryptogen 的生产替代方案