Re: Adding fields on the fly

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Gail Zacharias <gz(at)clozure(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Adding fields on the fly
Date: 2003-10-22 21:51:03
Message-ID: Pine.LNX.4.44.0310222350000.8099-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gail Zacharias writes:

> Is this even possible? Is ALTER TABLE supported?

Yes. (RTFM)

> If so, what performance characteristics can I expect? Compared to, say,
> inserting a record, can I expect this to be 10 times slower? 1000 times
> slower? What does the performance depend on? Number of rows? Number of
> columns? Number of tables? anything else?

Adding a column runs in constant time.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-10-22 21:53:10 Re: Indexes and querys
Previous Message Josué Maldonado 2003-10-22 21:29:56 Indexes and querys