On 23 February 2010 13:43, Stefan Schwarzer <stefan.schwar...@grid.unep.ch> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
