Toma Vailikit schrieb:
>
> Postgres is MUCH happier to do many more queries that pull from little
> tables than to do one query from one bigger table. The biggest table I have
> at this point will always be the main index table, which now holds about 400
> rows.
>
But this is typical for every database !?
* Smaller tables increases the chance, that no further pages have to
be reloaded from disc. The table is fully in RAM.
* Smaller tables does mean smaller indices storage or perhaps even
no need for indices.
etc ....
Marten