Postgres Pro
Downloads
Home   >   mailing lists

Re: Partitioning - Mailing list pgsql-general

From John R Pierce
Subject Re: Partitioning
Date
Msg-id 54BCBCFF.5040100@hogranch.com
Whole thread Raw
In response to Re: Partitioning  (James Sewell <james.sewell@lisasoft.com>)
Responses Re: Partitioning  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Re: Partitioning  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
List pgsql-general
Tree view
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 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.

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: James Sewell
Date:
Subject: Re: Partitioning
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Partitioning