Large slow tables in PostgreSQL can sometimes work more quickly by being split into smaller tables. Table inheritance magic makes them appear as one table. Instead of using an index to find matching rows from the big table, the query will only search the matching tables.

Sign in to participate in the conversation

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!