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

From Joseph Shraibman
Subject Re: why does this select hang postgres???
Date
Msg-id 3B742CA8.9000502@selectacast.net
Whole thread Raw
In response to why does this select hang postgres???  (Jeremy Hansen <jeremy@xxedgexx.com>)
List pgsql-general
How do you know it is just sitting there.  Do you see that cpu isn't
being used?  How many rows do you expect this to return? What version of
postgres? (do a select version())

Jeremy Hansen wrote:
> 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.
>
> Thank You!
> -jeremy
>
>


--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_xlog directory filled file system
Next
From: Stephan Szabo
Date:
Subject: Re: why does this select hang postgres???