Re: PG index architecture

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PG index architecture
Date: 2014-07-15 22:02:54
Message-ID: 53C5A50E.50508@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/15/2014 2:54 PM, Andy Colson wrote:
>
> Ah, yea, sorry, I don't really mean record #1, I mean hard drive seek
> to address 1. (where address came from the index lookup)

of course, its a file+offset, so there's at least 1-2 more levels of
indirection before you get to physical addresses on the hard disk.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John McKown 2014-07-16 01:42:59 Re: Design ? table vs. view?
Previous Message Andy Colson 2014-07-15 21:54:00 Re: PG index architecture