Re: When do vacuumed pages/tuples become available for reuse? - Mailing list pgsql-general

From Michael Lewis
Subject Re: When do vacuumed pages/tuples become available for reuse?
Date
Msg-id CAHOFxGph35T4z-gHTksNiK=hLBUvr0dF_B_PDpVA9-bnyYfs2g@mail.gmail.com
Whole thread Raw
In response to Re: When do vacuumed pages/tuples become available for reuse?  (rihad <rihad@mail.ru>)
Responses Re: When do vacuumed pages/tuples become available for reuse?  (Michael Paquier <michael@paquier.xyz>)
Re: When do vacuumed pages/tuples become available for reuse?  (rihad <rihad@mail.ru>)
List pgsql-general
Way to many indexes. I'm going to have a hard time convincing our programmers to get rid of any of them )

You can create (concurrently) an identical index with a new name, then drop old version concurrently and repeat for each. It doesn't help you figure out the root cause and how to prevent it from happening again, but gets you to a fresh start at least.

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: When do vacuumed pages/tuples become available for reuse?
Next
From: Michael Paquier
Date:
Subject: Re: When do vacuumed pages/tuples become available for reuse?