Re: Big databases vs small databases

----- Original Message -----
From: "Wim" <wdh@belbone.be>
To: "Sugrue, Sean" <Sean.Sugrue@analog.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Wednesday, February 18, 2004 8:55 AM
Subject: Re: [NOVICE] Big databases vs small databases

> If it is a table without indexes
> and constraints, it doesn't matter how big your DB is

AFAIK postgres adds an implicit B-tree index over the primary key to a table
that has no index. Rebuilding a B-Tree should take longer for a larger tree,
especally if newly added index keys are already sorted.

> I hope that I'm right, because these are only thoughts. I didn't perform
> any tests. The specialists may correct me if I'm wrong :-)

Same here. :-P

chris