Re: Lack of Performance - Mailing list pgsql-admin

From M.Feldtmann@t-online.de (Marten Feldtmann)
Subject Re: Lack of Performance
Date
Msg-id 3A1FFA1A.B3F28A7D@toppoint.de
Whole thread Raw
In response to RE: Lack of Performance  ("Toma Vailikit" <toma@nutz.org>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: Fausto Guzzetti
Date:
Subject: Postgresql on Solais 7
Next
From: yangcy@dawn.co.jp (yangchuanyan)
Date:
Subject: InitDB_Problem