Re: Plsql Function with error: No space left on device.

From: "David M(dot) Richter" <D(dot)Richter(at)DKFZ-heidelberg(dot)de>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Plsql Function with error: No space left on device.
Date: 2001-06-26 11:32:53
Message-ID: 3B3872E5.65A6B538@DKFZ-heidelberg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 Content-Type Size
D.Richter.vcf text/x-vcard 468 bytes

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David M. Richter 2001-06-26 13:24:21 Re: Plsql Function with error: No space left on device.
Previous Message Antti Linno 2001-06-26 11:32:40 TEXT field size