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