Procedure for adding a column

From: david_shadovitz(at)xontech(dot)com (David Shadovitz)
To: pgsql-general(at)postgresql(dot)org
Subject: Procedure for adding a column
Date: 2003-10-09 16:05:18
Message-ID: 8b37e2e5.0310090805.257d4b6f@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to add a column to a table. This table holds several thousand
records, has several indexes, and serves as the parent table to a few
child tables.

When I've done this in the past, it has taken quite a long time for
the ALTER TABLE command to complete.

So, what is the correct procedure for adding a column? Drop the
indexes, add the column, and recreate the indexes?

Thanks.
-David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-10-09 16:16:38 Re: Response from MySql AB (Re: Humor me: Postgresql vs.
Previous Message Andrew Sullivan 2003-10-09 16:05:08 Re: Response from MySql AB (Re: Humor me: Postgresql vs.