Re: [PERFORM] postgresql 9.6 data directory fs becomes full

2017-09-11 Thread Jerry Sievers
Mariel Cherkassky writes: > I want to check something regarding postgresql performance during my > app is running. > > My app does the next things on 20 tables in a loop : > > 1.truncate table. > 2.drop constraints on table > 3.drop indexes on table > 4.insert into local_table select * from remot

Re: [PERFORM] postgresql 9.6 data directory fs becomes full

2017-09-11 Thread Tom Lane
Mariel Cherkassky writes: > My app does the next things on 20 tables in a loop : > 1.truncate table. > 2.drop constraints on table > 3.drop indexes on table > 4.insert into local_table select * from remote_oracle_table > 4.1.Recently I'm getting an error in this part : SQLERRM = could not extend