Skip site navigation (1) Skip section navigation (2)

Re: Lack of Performance

From: M(dot)Feldtmann(at)t-online(dot)de (Marten Feldtmann)
To: toma(at)nutz(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Lack of Performance
Date: 2000-11-25 17:42:50
Message-ID: 3A1FFA1A.B3F28A7D@toppoint.de (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-admin by date

Next:From: yangchuanyanDate: 2000-11-27 01:01:58
Subject: InitDB_Problem
Previous:From: Toma VailikitDate: 2000-11-25 17:25:29
Subject: RE: Lack of Performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group