Re: [PERFORM] Pageinspect bt_metap help

2017-09-17 Thread Peter Geoghegan
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

[PERFORM] Pageinspect bt_metap help

2017-09-17 Thread Neto pr
Hello All 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. The height of the b-tree (position of node farthest from r

[PERFORM] Partitioning perfomance issue

2017-09-17 Thread Konstantin Kivi
I tried to use partitioning and have problem with it, as I get very bad perfomance. I cannot understand, what I am doing wrong. I set up master and child tables via inheritance, with range CHECK by date and with trigger on 'insert', as described in the documentation. I was happy with insertion s