At 02:20 AM 3/25/2009, [email protected] wrote:
To: Zdravko Balorda
cc: [email protected]
Subject: Re: Alter Table/Indexing
In-reply-to: <[email protected]>
References: <[email protected]>
Comments: In-reply-to Zdravko Balorda
message dated "Tue, 24 M
Zdravko Balorda 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 doi
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
--
Sent via pgsql-sql mail
