query pegs beta4 - Mailing list pgsql-general

From Louis-David Mitterrand
Subject query pegs beta4
Date
Msg-id 20071215173043.GA24162@apartia.fr
Whole thread Raw
Responses Re: query pegs beta4
List pgsql-general
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 haven't tried it on other versions
of postgres.

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: postgres cannot access the server configuration file
Next
From: Tom Lane
Date:
Subject: Re: query pegs beta4