Re: BUG #14932: SELECT DISTINCT val FROM table gets stuck in an infinite loop

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>

To: "Todd A. Cook" <tcook@blackducksoftware.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, Thomas Munro <thomas.munro@enterprisedb.com>, PostgreSQL Bugs <pgsql-bugs@postgresql.org>

Date: 2018-01-29T19:26:47Z

Lists: pgsql-bugs

On 2018-01-29 13:56:37 -0500, Todd A. Cook wrote:
> With those patches applied, I'm able to process a 175 million row data set
> without any problems.

Cool!

> I'll try the 900 million row set next.

Thanks!

- Andres

Commits

Improve bit perturbation in TupleHashTableHash.
- d18d4bca81f8 10.2 landed
- c068f87723ca 11.0 landed
Prevent growth of simplehash tables when they're "too empty".
- d1aac2998789 10.2 landed
- ab9f2c429d8f 11.0 landed
Add stack-overflow guards in set-operation planning.
- 1b2a3860d3ea 10.2 cited