temporary table size

From: "Makiko Kudo" <ma-kudo(at)fjb(dot)co(dot)jp>
To: <pgsql-general(at)postgresql(dot)org>
Subject: temporary table size
Date: 2000-10-17 05:27:46
Message-ID: 022501c037fa$fb55f4c0$6d251cac@s075d555.local.fjb.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, now I am using Linux Red Hat 6.2J, and the disk is being storage raid
0(stripe set)
4GbyteX4=16. I installed PostgreSql7.02 into this machine, and
as making database, there is several error messages.
First of all, I create table, and whether it is because disk raid,
or postgress, error message came out.
========================================================
#created table time_sum_200006
#and carried out
INSERT into time_sum_200006
(Select time,
SUM(visit),
SUM(bytes)
from logdb_200006
group by time);

ERROR: ltsReadBlock: failed to read block 16672 of temporary file

ERROR: cannot read block 41419 of logdb_200006(second trial)
======================================================
Maybe this happened because lack of disk space, for temporary table
may be too small to put datas.
Is it possible to disperse size of temporary table, just as oracle's alter
table space?
Or is there another way to user disk raid, and if not raid, how can sum up
the size?

best regards,

Makiko Kudo

Browse pgsql-general by date

  From Date Subject
Next Message Franck Martin 2000-10-17 06:30:59 RE: storing binary data - PGSQL book/documentation
Previous Message Bruce Momjian 2000-10-17 05:11:43 I am done going through my mailbox