On 23 February 2010 13:43, Stefan Schwarzer <stefan.schwarzer@xxxxxxxxxxxx> wrote: >>>> 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? Thom -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
