ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space...

From: "Ligia M(dot) Pimentel" <lmpc(at)nettaxi(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space...
Date: 2001-01-17 17:14:56
Message-ID: 944kbb$114p$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ligia M. Pimentel 2001-01-17 17:59:53 Re: ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space...
Previous Message Ross J. Reedstrom 2001-01-17 17:14:26 Re: outer join in PostgreSql