testdb01=# create table coords (id bigint generated always as identity primary key, coords numeric[]);
CREATE TABLE
testdb01=# insert into coords (coords) values ('{35.90495759611745, 42.094352549322274}'), ('{63.234624356235, 121.274572465431}');
INSERT 0 2
testdb01=# table coords;
id | coords
----+----------------------------------------
1 | {35.90495759611745,42.094352549322274}
2 | {63.234624356235,121.274572465431}
(2 rows)
каталог папки base и global
FATAL: invalid page in block 0 of relation global/1260".
location / {
proxy_set_header X-Real-IP $remote_addr;
proxy_pass http://192.168.1.100;
}
ALTER TABLE ... ADD COLUMN ...
, описанная в документации, например, тут: https://postgrespro.ru/docs/postgresql/16/sql-alte... show shared_buffers;
show work_mem;
show random_page_cost;