At 02:20 AM 3/25/2009, pgsql-sql-ow...@postgresql.org wrote:
To: Zdravko Balorda
cc: pgsql-sql@postgresql.org
Subject: Re: Alter Table/Indexing
In-reply-to: <49c89fea.8060...@siix.com>
References: <49c89fea.8060...@siix.com>
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