Re: query pegs beta4

Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org> writes:
> This new query of mine pegs beta4, it doesn't return and CPU is at 100%:
>     select l.id_location,l.name,
>             a.city
>             from location l, address a, show_date x, show s, show s2
>             where (l.id_address = a.id_address
>             and x.id_location = l.id_location
>             and s.id_show = x.id_show
>             and s2.show_type = s.show_type and s2.id_show = 305)
>             or l.id_location = 172;

> The tables are not big, at most a few hundred elements each, if that.

> Maybe the query itself is flawed,

I'd say so.  Any l row with id_location = 172 joins to the cartesian
product of all the other tables.  I doubt that's what you meant.

            regards, tom lane