Re: Alter Table/Indexing - Mailing list pgsql-sql

From Tom Lane
Subject Re: Alter Table/Indexing
Date
Msg-id 27189.1237905331@sss.pgh.pa.us
Whole thread Raw
In response to Alter Table/Indexing  (Zdravko Balorda <zdravko.balorda@siix.com>)
List pgsql-sql
Zdravko Balorda <zdravko.balorda@siix.com> writes:
> 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.

ALTER TABLE TYPE already rebuilds the indexes; you won't make the
overall process any faster by doing that by hand.
        regards, tom lane


pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps
Next
From: Peter Willis
Date:
Subject: Proper entry of polygon type data