Re: Partitioning

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Partitioning
Date: 2015-01-19 08:14:55
Message-ID: 54BCBCFF.5040100@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2015-01-19 08:42:06 Re: Partitioning
Previous Message James Sewell 2015-01-19 07:59:06 Re: Partitioning