alter table add column implementation undesirable?

From: Forest Wilkinson <fspam(at)home(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: alter table add column implementation undesirable?
Date: 2000-11-09 03:55:22
Message-ID: er7k0t0phdg6am1q34utjldrp76vtscf26@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message pgsql-sql 2000-11-09 06:26:31 alter pg_shadow
Previous Message Tom Lane 2000-11-09 02:41:37 Re: shared memory problem