Re: why does this select hang postgres??? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: why does this select hang postgres???
Date
Msg-id 200108101829.f7AITeI24740@candle.pha.pa.us
Whole thread Raw
In response to why does this select hang postgres???  (Jeremy Hansen <jeremy@xxedgexx.com>)
Responses Re: why does this select hang postgres???  (Jeremy Hansen <jeremy@xxedgexx.com>)
List pgsql-general
>
> select * from env_info,summary,plat_info;
>
> Is my statement broken?  Is this not legal?  Postgres just sits there....
>
> My goal is to select everything from multiple tables with one sql
> statement.

You didn't join the tables.  This will join each row to every other row.
This will take a long time.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From:
Date:
Subject: Re: why does this select hang postgres???
Next
From: Mike Mascari
Date:
Subject: Re: why does this select hang postgres???