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

Mariel Cherkassky <mariel.cherkassky@gmail.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance