Alter Table/Indexing - Mailing list pgsql-sql

From Zdravko Balorda
Subject Alter Table/Indexing
Date
Msg-id 49C89FEA.8060804@siix.com
Whole thread Raw
Responses Re: Alter Table/Indexing  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] bash & postgres
Next
From: Jasen Betts
Date:
Subject: Re: alter table on a large db