Hi,
Please help me on this.
We are migrating our application from Oracle to Postgres.
So we have some big tables where partitioning and indexing is implemented we
are migrating into postgres.
For postgres we are rebuilding the indexes by running create concurrently,
drop, alter schema insid
quier [mailto:michael.paqu...@gmail.com]
Sent: Saturday, May 27, 2017 1:44 AM
To: Euler Taveira
Cc: Jashobanta Mahapatra; pgsql-docs@postgresql.org
Subject: Re: [DOCS] postgres index rebuild
On Fri, May 26, 2017 at 3:24 PM, Euler Taveira wrote:
> CIC can't be executed inside a transaction block or a
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.3/static/routine-reindex.html
Description:
Hi,
As per the doc provided by postgres, for rebuild index we can do
concurrently which doesn't take any lock.
1)create new index concurrently wi
