Re: Support for REINDEX CONCURRENTLY - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Support for REINDEX CONCURRENTLY
Date
Msg-id 20121012181741.GN29165@tamriel.snowman.net
Whole thread Raw
In response to Re: Support for REINDEX CONCURRENTLY  (Jim Nasby <jim@nasby.net>)
Responses Re: Support for REINDEX CONCURRENTLY  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
* Jim Nasby (jim@nasby.net) wrote:
> Yeah, I was just trying to remember what other situations this has come up in. My recollection is that there's been a
coupleother cases where that would be useful.
 

Yes, I've run into similar issues in the past also.  It'd be really neat
to somehow make the SnapshotNow (and I'm guessing the whole SysCache
system) behave more like MVCC.

> My recollection is also that such a change would be rather large... but it might be smaller than all the other
work-aroundsthat are needed because we don't have that...
 

Perhaps..  Seems like it'd be a lot of work tho, to do it 'right', and I
suspect there's a lot of skeletons out there that we'd run into..
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Abhijit Menon-Sen
Date:
Subject: Re: [PATCH] explain tup_fetched/returned in monitoring-stats
Next
From: Hannu Krosing
Date:
Subject: Re: Deprecating RULES