Postgres Pro
Downloads
Home   >   mailing lists

Droping indexes - Mailing list pgsql-sql

From Mario Behring
Subject Droping indexes
Date
Msg-id 726736.33764.qm@web30001.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Droping indexes  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-sql
Tree view
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

Looking for earth-friendly autos?
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

pgsql-sql by date:

Previous
From: William Scott Jordan
Date:
Subject: Re: Resolved - Referencing tables are grinding UPDATE to
Next
From: Mario Behring
Date:
Subject: Re: Droping indexes