Re: [Testcase] Queries running forever, because of wrong rowcount estimate

2023-02-13 Thread Peter
On Mon, Feb 13, 2023 at 12:38:12PM -0500, Tom Lane wrote: ! Peter writes: ! > "rows=1" in the "Hash Anti Join" line is WRONG. It should be ! > 300. Or at least some thousands. ! ! FWIW, this behaves better in v14 and up. In older versions there's ! an ambiguity about what relpages=reltuples=

Re: [Testcase] Queries running forever, because of wrong rowcount estimate

2023-02-13 Thread Tom Lane
Peter writes: > "rows=1" in the "Hash Anti Join" line is WRONG. It should be > 300. Or at least some thousands. FWIW, this behaves better in v14 and up. In older versions there's an ambiguity about what relpages=reltuples=0 means; it's the state when ANALYZE has never yet examined the table