Horton

Re: pgsql 10: hash indexes testing

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, AP <ap@zip.com.au>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2017-08-04T17:29:28Z
Lists: pgsql-hackers 
On Fri, Aug 4, 2017 at 6:22 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> I have increased the number of hash bitmap pages as a separate patch.
> I am not completely sure if it is a good idea to directly increase it
> to 1024 as that will increase the size of hashmetapagedata from 960
> bytes to 4544 bytes.  Shall we increase it to 512?

I don't quite see what the problem is with increasing it to 4544
bytes.  What's your concern?

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

Commits

  1. pgstatindex: Insert some casts to prevent overflow.

  2. hash: Immediately after a bucket split, try to clean the old bucket.

  3. hash: Increase the number of possible overflow bitmaps by 8x.

  4. BRIN auto-summarization