| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: postgresql 9.6 data directory fs becomes full |
| Date: | 2017-09-11 12:02:28 |
| Message-ID: | 11320.1505131348@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2017-09-11 17:07:56 | Re: postgresql 9.6 data directory fs becomes full |
| Previous Message | Mariel Cherkassky | 2017-09-11 09:42:01 | postgresql 9.6 data directory fs becomes full |