Search Postgresql Archives

Re: When do vacuumed pages/tuples become available for reuse?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux