Re: Analyzing bug 8049 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Analyzing bug 8049
Date
Msg-id 19107.1365782881@sss.pgh.pa.us
Whole thread Raw
In response to Re: Analyzing bug 8049  ("Dickson S. Guedes" <listas@guedesoft.net>)
List pgsql-hackers
"Dickson S. Guedes" <listas@guedesoft.net> writes:
> In my tests, after ANALYZE _bug_header and _bug_line, the query plan
> changes and query results returns as expected. Is this a chance that
> things isn't too bad?

No, it just means that in this particular scenario, the bug only
manifests if a nestloop plan is chosen --- without that, there's no
possibility of pushing a join clause down to the scan level anyway.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Detach/attach table and index data files from one cluster to another
Next
From: Kevin Grittner
Date:
Subject: Re: (auto)vacuum truncate exclusive lock