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
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.
In response to
pgsql-admin by date
|Next:||From: yangchuanyan||Date: 2000-11-27 01:01:58|
|Previous:||From: Toma Vailikit||Date: 2000-11-25 17:25:29|
|Subject: RE: Lack of Performance|