Jeff Janes wrote:
> I've written a function which allows users to clean up the pending list.
> It takes the index name and returns the number of pending list pages
> deleted.
I just noticed that your patch uses AccessShareLock on the index. Is
that okay? I would have assumed that you'd need ShareUpdateExclusive
(same as vacuum uses), but I don't really know. Was that a carefully
thought-out choice?
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services