Notes on Installing PostgreSQL on All Platforms

If you are using PostgreSQL, you will need to increase the join collapse limit. Edit postgresql.conf and change the following line:

# join_collapse_limit = 8


join_collapse_limit = 10

If you do not do this step, you may see the following error when running complex queries:

org.postgresql.util.PSQLException: ERROR: failed to build any 8-way joins


Was this content helpful?

Log in or register an account to provide feedback

expand all collapse all