pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space...
3+ messages / 2 participants
[nested] [flat]

* ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space...
@ 2001-01-17 17:14  Ligia M. Pimentel <lmpc@nettaxi.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Ligia M. Pimentel @ 2001-01-17 17:14 UTC (permalink / raw)
  To: 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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space...
@ 2001-01-17 17:59  Ligia M. Pimentel <lmpc@nettaxi.com>
  parent: Ligia M. Pimentel <lmpc@nettaxi.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Ligia M. Pimentel @ 2001-01-17 17:59 UTC (permalink / raw)
  To: pgsql-sql

I fixed it!, it just added an index!
Thanks anyway...

"Ligia M. Pimentel" <lmpc@nettaxi.com> 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
>
>





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Re: ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space...
@ 2001-01-18 21:46  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Ligia M. Pimentel <lmpc@nettaxi.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2001-01-18 21:46 UTC (permalink / raw)
  To: Ligia M. Pimentel <lmpc@nettaxi.com>; +Cc: pgsql-sql

"Ligia M. Pimentel" <lmpc@nettaxi.com> writes:
>> 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

What plan does EXPLAIN show for this query?  I suspect that you are
causing it to sort a huge intermediate result, possibly because of
insufficiently tight WHERE restrictions.

>>  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.

Well, that temp file alone is 27231*8K = 212meg, and it might be using
several.  So running out of disk space is not out of the question.  Did
you watch free space with df while the query was running?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-01-18 21:46 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-17 17:14 ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space... Ligia M. Pimentel <lmpc@nettaxi.com>
2001-01-17 17:59 ` Ligia M. Pimentel <lmpc@nettaxi.com>
2001-01-18 21:46   ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox