Received: from newmail.DKFZ-Heidelberg.DE (newmail.inet.dkfz-heidelberg.de [193.174.53.39]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5QBYra98104 for ; Tue, 26 Jun 2001 07:34:53 -0400 (EDT) (envelope-from D.Richter@DKFZ-heidelberg.de) Received: from perkeo.inet.dkfz-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by newmail.DKFZ-Heidelberg.DE (8.9.3/8.9.3/DKFZ-8.9.3) with ESMTP id NAA15022; Tue, 26 Jun 2001 13:34:44 +0200 (MET DST) Received: from DKFZ-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by perkeo.inet.dkfz-heidelberg.de (980427.SGI.8.8.8/DKFZ-8.6.4) with ESMTP id NAA05032; Tue, 26 Jun 2001 13:32:54 +0200 (MDT) Message-ID: <3B3872E5.65A6B538@DKFZ-heidelberg.de> Date: Tue, 26 Jun 2001 13:32:53 +0200 From: "David M. Richter" Organization: German Cancer Research Center X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en MIME-Version: 1.0 To: Richard Huxton CC: pgsql-sql@postgresql.org Subject: Re: Plsql Function with error: No space left on device. References: <3B36FB6E.1039F0D4@DKFZ-heidelberg.de> <005601c0fd60$db576740$1001a8c0@archonet.com> Content-Type: multipart/mixed; boundary="------------6B813364DA9882CB53C50684" X-Archive-Number: 200106/412 X-Sequence-Number: 3709 This is a multi-part message in MIME format. --------------6B813364DA9882CB53C50684 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 --------------6B813364DA9882CB53C50684 Content-Type: text/x-vcard; charset=us-ascii; name="D.Richter.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for David M. Richter Content-Disposition: attachment; filename="D.Richter.vcf" begin:vcard url;quoted-printable:http://mbi.DKFZ-Heidelberg.de/=0D=0A n:M. Richter;David x-mozilla-html:FALSE org:Deutsches Krebsforschungszentrum;Division Medizinische und Biologische Informatik version:2.1 email;internet:d.richter@dkfz-heidelberg.de adr;quoted-printable:;;Im Neuenheimer Feld 280 url: http://mbi.DKFZ-Heidelberg.de/=0D=0AD-69120 Heidelberg, Germany ;Heidelberg;Germany;; x-mozilla-cpt:;-15296 fn:David M. Richter end:vcard --------------6B813364DA9882CB53C50684--