Peter Geoghegan writes:
> On Mon, Sep 18, 2017 at 7:31 AM, Neto pr wrote:
>> In my example, the values of fast_root, fast_root are equal to root, level,
>> I believe that due to the newly created index and no delete operations
>> occurred in the table.
> Fast root and true root will probably nev
On Mon, Sep 18, 2017 at 7:31 AM, Neto pr wrote:
> In my example, the values of fast_root, fast_root are equal to root, level,
> I believe that due to the newly created index and no delete operations
> occurred in the table.
Fast root and true root will probably never be different, even when
there
Very interesting information.
See if I'm right, so for performance purposes, would it be better to
consider the columns: fast_root and fast_level instead of the root and
level columns?
I have read that even deleting records the B-tree tree is not rebuilt, so
it does not cause overhead in dbms, and
On Sun, Sep 17, 2017 at 2:52 PM, Neto pr wrote:
> I am using Postgresql extension pageinspect.
>
> Could someone tell me the meaning of these columns: magic, version, root,
> level, fastroot, fastlevel of the bt_metap function.
>
> This information is not presents in the documentation.
A magic nu
