Re: Subqueries or Joins? Problems with multiple table query - Mailing list pgsql-general

>>>>> Select countries.name, basel.year, basel.value, cites.year,
>>>>> cites.value
>>>>> From countries
>>>>> Left Join basel on basel.id_country = countries.id_country and
>>>>> basel.value=1
>>>>> Left Join cites on cites.id_country = countries.id_country and
>>>>> cites.value=1
>>>>
>>>> I would have thought so, but the query turns forever.
>>>
>>> How many rows in each of your tables, and what indexes do you have?
>>
>> around 5000 rows
>>
>
> It takes a long time for just 5000 rows?  Could you provide the
> execution plan for it by putting EXPLAIN ANALYZE at the front of your
> query and post the result here?

Ok, seems to be a problem with the server and a running process or so.
On my local machine: great! Works fine. Thanks a lot for your help!