sql - 如何加快 PostgreSQL 中的 INSERT 请求?
问题描述
在PostgreSQL数据库中,我有这样的表:
CREATE TABLE IF NOT EXISTS layers (ID NUMERIC, GEOM GEOMETRY, CITY VARCHAR, AGGREGATION_METHOD VARCHAR, INFO JSON);
~700
我正在尝试使用这样一个查询向该表中插入记录:
INSERT INTO layers (ID, GEOM, CITY, AGGREGATION_METHOD, INFO) VALUES
(107509018555, '0203000020E61000000100000005000000000000808531534000000020749D4540000000808531534000000080159E4540000000201731534000000080159E4540000000201731534000000020749D4540000000808531534000000020749D4540', 'New York', 'MONTHLY', '[{"time":"2019-10-01T00:00:00Z","gender_details":[{"gender":"Male"},{"gender":"Female"}]}]'),
(107509018556, '0303000020E610000001000000050000000000008085315340000000A0D29A4640000000808531534000000020749D4540000000201731534000000020749D45400000002017315340000000A0D29C45400000008085315340000000A0D29C4540', 'London', 'MONTHLY', '[{"time":"2019-10-01T00:00:00Z","gender_details":[{"gender":"Male"},{"gender":"Female"}]}]')
... other 698 values
该查询运行 9-10 秒。有没有办法加快 PostgreSQL 数据库中的插入请求?
PostgreSQL 版本:11.0(在 Red Hat 上运行)
解决方案
推荐阅读
- python - use python request to load more items
- elasticsearch - 动态映射大于 2^63 - 1 的数值字段数据类型(long 类型)
- url-routing - TYPO3 9.5 URL Routing with URL Segment is not working
- javascript - 如何从 Vue.js 中的模板调用方法?
- c# - Application Gets Slow After Enable/Disable MDIChldren
- php - Use a function declared in a different file [PHP-HTML]
- windows - Maximum elements to loop over in fortran in linux and windows
- amazon-web-services - Aws iot 和 lorawan 集成
- java - 如何定义地图,其中键是天,值是列表
- python - 如果列表索引之一超出范围,如何为两个列表编写条件