Help with Inner Join: "No space left on device"

Asked

Viewed 326 times

1

I don’t have much knowledge in programming and experience in SQL, however, I need to do a search in a Postrgeesql database (I’m using pgAdminIIII) where I need to join two tables. 

create table table_new as 
select table.x1, table.x2, table.x3, table.x4, table2.x1, table2.x5, table2.x6, table2.x1 as teste
from table inner join table2 on table.x1 = table2.x1

However, with this search I end up fearing the following error message:

ERROR: could not extend file "base/17675/43101.15": No space left on device
SQL state: 53100
Hint: Check free disk space.

Could someone give me a tip on how to optimize my search so I can join the two tables I need??

memory join inner pgadmin
  • 1

    Have you tried to free up storage/disk space, depending on the error message? Or use a Where to filter only the desired data, who knows.

1 answer

1

It seems that the problem is not related to postgresql. The computer is out of free space, that’s all: "No space left on device"

Browser other questions tagged memory join inner pgadmin

You are not signed in. Login or sign up in order to post.