Allocating too much memory to Postgres can actually slow down performance, especially during index builds. The author explains how exceeding certain memory thresholds can lead to inefficient data processing and increased write operations, which negatively impact speed. It's better to use modest memory settings and adjust only based on proven benefits.