• PostgreSQL在何处处理 sql查询之二十一


    接前面:

    回到mdopen上来,看看是谁调用了 mdopen,又获得了什么。

    /*
     *    mdnblocks() -- Get the number of blocks stored in a relation.
     *
     *        Important side effect: all active segments of the relation are opened
     *        and added to the mdfd_chain list.  If this routine has not been
     *        called, then only segments up to the last one actually touched
     *        are present in the chain.
     */
    BlockNumber
    mdnblocks(SMgrRelation reln, ForkNumber forknum)
    {
        MdfdVec    *v = mdopen(reln, forknum, EXTENSION_FAIL);
        BlockNumber nblocks;
        BlockNumber segno = 0;
    
        /*
         * Skip through any segments that aren't the last one, to avoid redundant
         * seeks on them.  We have previously verified that these segments are
         * exactly RELSEG_SIZE long, and it's useless to recheck that each time.
         *
         * NOTE: this assumption could only be wrong if another backend has
         * truncated the relation.    We rely on higher code levels to handle that
         * scenario by closing and re-opening the md fd, which is handled via
         * relcache flush.    (Since the checkpointer doesn't participate in
         * relcache flush, it could have segment chain entries for inactive
         * segments; that's OK because the checkpointer never needs to compute
         * relation size.)
         */
        while (v->mdfd_chain != NULL)
        {
            segno++;
            v = v->mdfd_chain;
        }
    
        for (;;)
        {
            nblocks = _mdnblocks(reln, forknum, v);
        
    if (nblocks > ((BlockNumber) RELSEG_SIZE))
            
    elog(FATAL, "segment too big");
         if (nblocks < ((BlockNumber) RELSEG_SIZE))
            return (segno * ((BlockNumber) RELSEG_SIZE)) + nblocks;
            ...
    
            v = v->mdfd_chain;
        }
    }

     mdopen 获得的是一条链表指针,沿着这条链表,可以计算出所读取的数据库文件的块大小。

  • 相关阅读:
    常用HTTP Contenttype头信息及文件类型对照
    Web开发专用IDE:Aptana Studio 3.0
    如果张柏芝的孩子长大
    Apache日志分析工具Awstats的安装和配置
    台北貢寮~三貂角燈塔
    [转]ASP,PHP,JSP,ASP.NET 比较
    联想 Thinkpad SL410使用体验
    2011年6月TIOBE编程语言走势图及指数
    百度搜索能力越来越差了,看下图
    PHP 5.3.x中弃用的特性 Deprecated
  • 原文地址:https://www.cnblogs.com/gaojian/p/3102075.html
Copyright © 2020-2023  润新知