alter table add column implementation undesirable? - Mailing list pgsql-sql

From Forest Wilkinson
Subject alter table add column implementation undesirable?
Date
Msg-id er7k0t0phdg6am1q34utjldrp76vtscf26@4ax.com
Whole thread Raw
Responses Re: alter table add column implementation undesirable?
List pgsql-sql
A coworker told me that the postgres implementation of ALTER TABLE ADD
COLUMN creates an inefficient database.  He said it results in a table
whose new column is stored someplace other than the rest of the columns.
(A hidden auxiliary table?)  Is this true in postgres 6.5.3?  7.x?  Was it
ever true?

Forest Wilkinson



pgsql-sql by date:

Previous
From: Antti Linno
Date:
Subject: Re: insert value of form - checkboxes
Next
From: hubert depesz lubaczewski
Date:
Subject: how to write it in most efficient way?