Alter Table/Indexing

From: Zdravko Balorda <zdravko(dot)balorda(at)siix(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Alter Table/Indexing
Date: 2009-03-24 08:55:06
Message-ID: 49C89FEA.8060804@siix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I wonder does ATER TABLE TYPE, SET, depends on indexes, like INSERT does
in a sense it may be faster to drop and recreate index than sorting
after every row inserted. Does changing type or setting default on an
indexed column require sorting?

Thanks, Zdravko

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2009-03-24 09:15:52 Re: alter table on a large db
Previous Message Tom Lane 2009-03-23 19:55:13 Re: [SQL] bash & postgres