Re: Minmax indexes - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Minmax indexes
Date
Msg-id 20130926174043.GZ4832@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: Minmax indexes  ("Erik Rijkers" <er@xs4all.nl>)
List pgsql-hackers
Erik Rijkers wrote:

> I have the impression it's not quite working correctly.
> 
> The attached program returns different results for different values of enable_bitmapscan (consistently).

Clearly there's some bug somewhere.  I'll investigate it more.

> ( Btw, I had to make the max_locks_per_transaction higher for even not-so-large tables -- is that expected?  For a
100Mrow
 
> table, max_locks_per_transaction=1024 was not enough; I set it to 2048.  Might be worth some documentation,
eventually.)
 

Not documentation -- that would also be a bug which needs to be fixed.

Thanks for testing.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Minmax indexes
Next
From: Jim Nasby
Date:
Subject: Re: dynamic shared memory