Fairly certain hold em uses postgres.
In this case, a few things are probably happening to you:
1. You are using the stock configs.
2. You might not be running vacuum / analyze enough.
3. You don't have enough RAM to store the indexes in memory, causing the optimizer to choose bad query...