Re: PG index architecture - Mailing list pgsql-general

From John R Pierce
Subject Re: PG index architecture
Date
Msg-id 53C5A50E.50508@hogranch.com
Whole thread Raw
In response to Re: PG index architecture  (Andy Colson <andy@squeakycode.net>)
List 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



pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: PG index architecture
Next
From: John McKown
Date:
Subject: Re: Design ? table vs. view?