Re: No space left on device.

From: "Chad Thompson" <chad(at)weblinkservices(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: No space left on device.
Date: 2002-08-16 18:46:02
Message-ID: 033f01c24555$2d18c550$32021aac@chad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

HOLY DUMB!

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

> "Chad Thompson" <chad(at)weblinkservices(dot)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
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Aarni Ruuhimäki / Megative Tmi / KYMI.com 2002-08-16 18:53:37 Re: BLOBs
Previous Message Tom Lane 2002-08-16 18:43:40 Re: No space left on device.