Re: Big databases vs small databases - Mailing list pgsql-novice

From Christian Pöcher
Subject Re: Big databases vs small databases
Date
Msg-id 002001c3f67e$f681f4d0$4008cad4@dose
Whole thread Raw
In response to Big databases vs small databases  ("Sugrue, Sean" <Sean.Sugrue@analog.com>)
List pgsql-novice
----- 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


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error: query is too long. Maximum length is 16382
Next
From:
Date:
Subject: Cannot insert a duplicate key into unique index