Postgres Pro
Downloads
Home   >   mailing lists

Re: Plsql Function with error: No space left on device. - Mailing list pgsql-sql

From David M. Richter
Subject Re: Plsql Function with error: No space left on device.
Date
Msg-id 3B3872E5.65A6B538@DKFZ-heidelberg.de
Whole thread Raw
In response to Plsql Function with error: No space left on device.  ("David M. Richter" <D.Richter@DKFZ-heidelberg.de>)
List pgsql-sql
Tree view 
Hallo Richard!

Thanks a lot for Your hint. It works. Yeah.
But only in a little database of 1000 rows.
In my case with 4 milions of rows I was waiting 17 hours without any
success by using the processor 97%.
So I canceled the Job.
What could i optimize in this query?
Do You perhaps have another great hint?

Thanks a lot

David
Attachment

pgsql-sql by date:

Previous
From: Antti Linno
Date:
Subject: TEXT field size
Next
From: "David M. Richter"
Date:
Subject: Re: Plsql Function with error: No space left on device.