Postgres Pro
Downloads
Home   >   mailing lists

Thread: No space left on device.

No space left on device.

From
"Chad Thompson"
Date:
I have recieved a very weird error when running the following query.
 
select
 l.id, l.full_phone into "8_15_2002_NeverquitPushOneMessaging"
from
 list_tz l, call_results cr
where
 client_id = 8
and
 ((cr.result = 'Busy') or (cr.result = 'Busy-Reorder') or (cr.result = 'Busy-Timeout') or (cr.result = 'No Signal') or (cr.result = 'No Circuit Signal') or (cr.result = 'No Answer') or (cr.result = 'No Solicitation'))
and
 cr.calldate between '6/4/2002'  and '8/14/2002';
 
call_results is a table with just over 1 million lines, list_tz is a temp table created in another function w/ anywhere from 10 to 50 K lines.
 
here is the error
 
cannot extend 8_15_2002_NeverquitPushOneMessa: no space left on device
        check free disk space.
 
I have checked the archives and it gave me an indication that my sql might be wrong, but i cant figure out what.  I have also tried the query using IN (eg. and cr.result in('busy',busy-reorder....))
 
Here is my system info
 
Im running redhat 7.2
df says
Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/hda1             19188368   2960536  15253092  17% /
none                    385340         0    385340   0% /dev/shm
select version();
                          version
-----------------------------------------------------------
 PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
 
I have installed postgresql with just the default settings. 
 
Any help would be appreciated
TIA
Chad

Re: No space left on device.

From
Tom Lane
Date:
"Chad Thompson" <chad@weblinkservices.com> writes:
> select l.id, l.full_phone into "8_15_2002_NeverquitPushOneMessaging"=20
> from list_tz l, call_results cr=20
> where client_id =3D 8=20
> and ((cr.result =3D 'Busy') or (cr.result =3D 'Busy-Reorder') or (cr.result=
>  =3D 'Busy-Timeout') or (cr.result =3D 'No Signal') or (cr.result =3D 'No C=
> ircuit Signal') or (cr.result =3D 'No Answer') or (cr.result =3D 'No Solici=
> tation'))=20
> and cr.calldate between '6/4/2002'  and '8/14/2002';

> call_results is a table with just over 1 million lines, list_tz is a temp t=
> able created in another function w/ anywhere from 10 to 50 K lines.

Perhaps a join condition would be a good idea ;-).  As-is, you're
selecting from the cross product of those tables, which could be up to
50 billion lines.

            regards, tom lane

Re: No space left on device.

From
"Chad Thompson"
Date:
HOLY DUMB!

Thanks Tom
Chad
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Chad Thompson" <chad@weblinkservices.com>
Cc: "pgsql-novice" <pgsql-novice@postgresql.org>
Sent: Friday, August 16, 2002 12:43 PM
Subject: Re: [NOVICE] No space left on device.


> "Chad Thompson" <chad@weblinkservices.com> writes:
> > select l.id, l.full_phone into "8_15_2002_NeverquitPushOneMessaging"=20
> > from list_tz l, call_results cr=20
> > where client_id =3D 8=20
> > and ((cr.result =3D 'Busy') or (cr.result =3D 'Busy-Reorder') or
(cr.result=
> >  =3D 'Busy-Timeout') or (cr.result =3D 'No Signal') or (cr.result =3D
'No C=
> > ircuit Signal') or (cr.result =3D 'No Answer') or (cr.result =3D 'No
Solici=
> > tation'))=20
> > and cr.calldate between '6/4/2002'  and '8/14/2002';
>
> > call_results is a table with just over 1 million lines, list_tz is a
temp t=
> > able created in another function w/ anywhere from 10 to 50 K lines.
>
> Perhaps a join condition would be a good idea ;-).  As-is, you're
> selecting from the cross product of those tables, which could be up to
> 50 billion lines.
>
> regards, tom lane
>