Re: pgsql 10: hash indexes testing

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: AP <ap@zip.com.au>

Cc: Amit Kapila <amit.kapila16@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2017-08-10T17:12:25Z

Lists: pgsql-hackers

On Thu, Aug 10, 2017 at 6:41 AM, AP <ap@zip.com.au> wrote:
> The index is 135GB rather than 900GB (from memory/give or take).

Whoa.  Big improvement.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

pgstatindex: Insert some casts to prevent overflow.
- 0b7ba3d6474b 10.0 cited
hash: Immediately after a bucket split, try to clean the old bucket.
- ff98a5e1e49d 10.0 landed
hash: Increase the number of possible overflow bitmaps by 8x.
- 620b49a16d2a 10.0 landed
BRIN auto-summarization
- 7526e10224f0 10.0 cited