Re: Lack of Performance

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