Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit)
От
Tom Lane
Тема
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit)
Дата
Msg-id
11893.1520262041@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
[HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Sokolov Yura <funny.falcon@postgrespro.ru>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian abit) Sokolov Yura <funny.falcon@postgrespro.ru>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfiana bit) Sokolov Yura <funny.falcon@postgrespro.ru>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfiana bit) Sokolov Yura <funny.falcon@postgrespro.ru>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfiana bit) Sokolov Yura <funny.falcon@postgrespro.ru>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian abit) Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian abit) Yura Sokolov <funny.falcon@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian abit) Yura Sokolov <funny.falcon@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian abit) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian abit) Yura Sokolov <funny.falcon@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian abit) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian abit) Yura Sokolov <funny.falcon@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian abit) Yura Sokolov <funny.falcon@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Dmitry Dolgov <9erthalion6@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Dmitry Dolgov <9erthalion6@gmail.com>
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) Michael Paquier <michael.paquier@gmail.com>
Tomas Vondra writes: > Snapshots are static (we don't really add new XIDs into existing ones, > right?), so why don't we simply sort the XIDs and then use bsearch to > lookup values? That should fix the linear search, without need for any > local hash table. +1 for looking into that, since it would avoid adding any complication to snapshot copying. In principle, with enough XIDs in the snap, an O(1) hash probe would be quicker than an O(log N) bsearch ... but I'm dubious that we are often in the range where that would matter. We do need to worry about the cost of snapshot copying, too. regards, tom lane
В списке pgsql-hackers по дате отправления
От: Marko Tiikkaja
Дата: