Droping indexes

From: Mario Behring <mariobehring(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Droping indexes
Date: 2007-01-16 13:51:57
Message-ID: 726736.33764.qm@web30001.mail.mud.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

Please, if I drop all indexes from a table, can I recreate them after performing a vacuum full at this table? I mean, I do not know details about the indexes, so what I am asking is if I issue a REINDEX on this table, will it create the proper indexes again?

Please advise.

Thanks in advance.

Mario Behring


____________________________________________________________________________________
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives.
http://tools.search.yahoo.com/toolbar/features/mail/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Behring 2007-01-16 14:43:29 Re: Droping indexes
Previous Message William Scott Jordan 2007-01-15 22:55:28 Re: Resolved - Referencing tables are grinding UPDATE to