Re: Allow "snapshot too old" error, to prevent bloat

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Allow "snapshot too old" error, to prevent bloat
Дата
Msg-id 54E2391D.4010500@BlueTreble.com
обсуждение исходный текст
Ответ на Re: Allow "snapshot too old" error, to prevent bloat  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On 2/16/15 2:41 AM, Andres Freund wrote:
> Since you actually don't want cancellations for the long running
> reporting queries it very much might be sensible to switch to a more
> complicated version of HeapTupleSatisfiesVacuum() if there's longrunning
> queries. One that can recognize if rows are actually visible to any
> backend, or if there are just snapshots that see older rows. I've
> previously wondered how hard this would be, but I don't think it's
> *that*  hard. And it'd be a much more general solution.

Josh Berkus mentioned on IRC that they're working on improving vacuum, 
and I think it was something along these lines.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Perl coding error in msvc build system?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Allow "snapshot too old" error, to prevent bloat