Hi, At Mon, 19 Jan 2015 00:14:55 -0800, John R Pierce <pie...@hogranch.com> wrote in <54bcbcff.5040...@hogranch.com> > On 1/18/2015 11:59 PM, James Sewell wrote: > > > > Actually this brings up another question, if I have an unique integer > > index of 2.gb <http://2.gb> what percentage would I expect to read for > > a value that was higher or lower than all index values? > > a couple 8k blocks. its a b-tree.
Yeah, scanning children reading highest/lowest values for each of them would make it faster than the first single query. regards, -- Kyotaro Horiguchi NTT Open Source Software Center -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
