Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> 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 > file "base/16400/124810.23": wrote only 4096 of 8192 bytes at block > 3092001 > 5.create constraints on table > 6.create indexes on table. Hm, are you committing anywhere in this loop? If not, the old data remains on disk till you do end the transaction. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
