Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0IHZN075292 for ; Thu, 18 Jan 2001 12:35:23 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0HITA045469 for ; Wed, 17 Jan 2001 13:29:10 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f0HI6k134654 for pgsql-sql@postgresql.org; Wed, 17 Jan 2001 13:06:46 -0500 (EST) (envelope-from news) From: "Ligia M. Pimentel" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space... Date: Wed, 17 Jan 2001 11:59:53 -0600 Organization: Guatemala Lines: 25 Message-ID: <944mvl$11qo$1@news.tht.net> References: <944kbb$114p$1@news.tht.net> Reply-To: "Ligia M. Pimentel" X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-sql@postgresql.org X-Archive-Number: 200101/215 X-Sequence-Number: 880 I fixed it!, it just added an index! Thanks anyway... "Ligia M. Pimentel" wrote in message news:944kbb$114p$1@news.tht.net... > I have a database and a table with 70000 records (which i dont think it's > too much) > I join this table with another of about the same size and put a record > restriction (WHERE) and everything works out fine, but when I put two SUMs > over a couple of fields and add a GROUP BY I keep getting this error, > > ltsWriteBlock: failed to write block 27231 of temporary file > Perhaps out of disk space? > > I checked and I have over 1GB free so I figure this must have something to > do with configuration parameters. > > I'd appreciate any help. > > > Ligia > >