Re: Adding fields on the fly - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Adding fields on the fly
Date
Msg-id Pine.LNX.4.44.0310222350000.8099-100000@peter.localdomain
Whole thread Raw
In response to Adding fields on the fly  (Gail Zacharias <gz@clozure.com>)
List 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@gmx.net


pgsql-general by date:

Previous
From: Josué Maldonado
Date:
Subject: Indexes and querys
Next
From: Peter Eisentraut
Date:
Subject: Re: Indexes and querys