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