Re: Index

From: Ravi Krishna <sr_krishna(at)aol(dot)com>
To: Sonam Sharma <sonams1209(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index
Date: 2019-10-25 11:31:33
Message-ID: 22DDC49C-6FAD-4B45-AC05-464C263F7E98@aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> I have created indexes with certain set of columns. Now I want to remove one of the column and add new column. Can this done without dropping the index?
>

If you intent is to avoid taking that table offline while the index is being built, you can do this:

1. create index concurrently on the new set of columns
2. once (1) done drop old index

In response to

  • Index at 2019-10-25 05:34:47 from Sonam Sharma

Browse pgsql-general by date

  From Date Subject
Next Message Yessica Brinkmann 2019-10-25 11:37:06 I think that my data is saved correctly, but when printing again, other data appears
Previous Message Luca Ferrari 2019-10-25 11:13:00 Re: Index