Hey guys...need help. Running PostgreSQL 11 with postgis on a

Question

Hey guys...need help. Running PostgreSQL 11 with postgis on a

server with 100 gb ram and two tablespaces. The default one is on system ssd. The working tablespace (also temp_tablespaces) is on zfs raid 0 with 10tb. I want to create a Index on a big table 400.000.000.000 rows. Table had only 3 columns and is less than 1tb. Index creation is given an error...."can't write block *** on temp .... device has no space left." But there are more than 4 tb left (watching writes with Df while Index query runs). Any ideas?

#backend #devops #pgsql #programming #russian

0

26.12.2019

1 ответов

8 просмотров

Nikita Bogdanov · Accepted Answer

Nikita Bogdanov

https://www.postgresql.org/docs/11/sql-createindex.html

0

26.12.2019

172 похожих чатов

Hey guys...need help. Running PostgreSQL 11 with postgis on a

1 ответов

Похожие вопросы