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