德歌告诉你PostgreSQL的那些事
2898
外闻 2020-03-19 14:14:54 字数:1144

阿里云数据库专家德歌告诉你PostgreSQL的那些事

什么是云栖神侠传:

云栖社区(http://yq.aliyun.com/?utm_source=yqdg),是阿里云面向开发者群体的开放型社区。在云栖社区中,活跃着许多阿里技术大牛,他们在自己的技术领域都是佼佼者,具有一定的业界影响力。在社区,他们通过撰写技术博文、解答技术难题,为开发者贡献着自己的能量。

他们,就是云栖社区的技术神侠!

他们之中包括:

数据库神侠:阿里云数据库专家 周正中(德歌)、林晓斌(丁奇);

Java开发及架构神侠:淘宝架构师 杨志宏(青霖);

微服务技术神侠:阿里巴巴高级技术专家 邱小侠(肥侠)

… …

在第一期,我们将向您推荐数据库神侠:周正中(德歌)

http://yq.aliyun.com/topic/23utm_source=yqdg

PostgreSQL 开发者 阿里云 数据库 技术博客

德歌,社区昵称:digoal,阿里云数据库专家,是国内PostgreSQL的积极倡导者,是PostgreSQL中国用户会创始人之一。同时也擅长Linux、Docker、存储、虚拟化等技术。

德歌是目前云栖社区最活跃的阿里技术专家,贡献了近千篇博客,大多数是关于PostgreSQL方面的,PostgreSQL是当下最受关注的数据库系统,是目前世界上对数据类型支持最丰富、全功能的自由软件数据库。如果您感兴趣,德歌的专题一定不能错过!

云栖神侠传第一期:德歌告诉你PostgreSQL的那些事儿

他的读书推荐:《Greenplum源码》《PostgreSQL》

博文推荐: 1.Greenplum 2000亿 近似度查询 性能 以及注意事项

http://yq.aliyun.com/articles/7608?utm_source=yqdg

2. PostgreSQL 1000亿数据量 正则匹配 速度与激情

http://yq.aliyun.com/articles/7549?utm_source=yqdg

3.PostgreSQL 9.5 新特性之 - 水平分片架构与实践

http://yq.aliyun.com/articles/6635?utm_source=yqdg

4. PostgreSQL 如何潇洒的处理每天上百TB的数据增量

http://yq.aliyun.com/articles/8528?utm_source=yqdg

更多博文,可以访问德歌主页:http://yq.aliyun.com/users/1384833841157402?utm_source=yqdg

德歌还经常出没在云栖社区的问答频道,如果你有关于PostgreSQL的更多问题,欢迎前往提问:http://yq.aliyun.com/ask?utm_source=yqdg,相信德歌一定会为你详细解答。


0人参与回答
  • 未添加任何数据~~


提示信息

联系电话:
1585150508*
QQ交谈:
小编
站长微信:
站长邮箱: service@qingjiuzhubei.com
162.3msRequest Duration4MBMemory UsageGET zixun/detail/{id?}.htmlRouteAuth status
    • Booting (13.71ms)
    • Application (151.53ms)
      6 templates were rendered
      • site.zixun.detail (resources/views/site/zixun/detail.blade.php)8blade
        Params
        0
        prevArticle
        1
        nextArticle
        2
        newDetail
        3
        comment
        4
        hotnews
        5
        t
        6
        d
        7
        k
      • layouts.site.layout (resources/views/layouts/site/layout.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        device
        4
        isMobile
        5
        errors
        6
        prevArticle
        7
        nextArticle
        8
        newDetail
        9
        comment
        10
        hotnews
        11
        t
        12
        d
        13
        k
        14
        __empty_1
        15
        __currentLoopData
        16
        loop
        17
        hotnewsVal
      • layouts.site.top (resources/views/layouts/site/top.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        device
        4
        isMobile
        5
        errors
        6
        prevArticle
        7
        nextArticle
        8
        newDetail
        9
        comment
        10
        hotnews
        11
        t
        12
        d
        13
        k
        14
        __empty_1
        15
        __currentLoopData
        16
        loop
        17
        hotnewsVal
      • layouts.site.bottom (resources/views/layouts/site/bottom.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        device
        4
        isMobile
        5
        errors
        6
        prevArticle
        7
        nextArticle
        8
        newDetail
        9
        comment
        10
        hotnews
        11
        t
        12
        d
        13
        k
        14
        __empty_1
        15
        __currentLoopData
        16
        loop
        17
        hotnewsVal
      • common.upgrade_vip (resources/views/common/upgrade_vip.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        device
        4
        isMobile
        5
        errors
        6
        prevArticle
        7
        nextArticle
        8
        newDetail
        9
        comment
        10
        hotnews
        11
        t
        12
        d
        13
        k
        14
        __empty_1
        15
        __currentLoopData
        16
        loop
        17
        hotnewsVal
      • kefu.kefu (resources/views/kefu/kefu.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        device
        4
        isMobile
        5
        errors
        6
        prevArticle
        7
        nextArticle
        8
        newDetail
        9
        comment
        10
        hotnews
        11
        t
        12
        d
        13
        k
        14
        __empty_1
        15
        __currentLoopData
        16
        loop
        17
        hotnewsVal
      uri
      GET zixun/detail/{id?}.html
      middleware
      web
      controller
      App\Http\Controllers\Site\ZixunController@detail
      namespace
      App\Http\Controllers
      prefix
      /zixun
      where
      as
      zixunDetail
      file
      app/Http/Controllers/Site/ZixunController.php:105-132
      7 statements were executed136.62ms
      • select * from `news` where `news`.`id` = '65992' and `news`.`deleted_at` is null limit 13.4ms/app/Http/Controllers/Site/ZixunController.php:109zzshuju
        Metadata
        Bindings
        • 0. 65992
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 14. /app/Http/Controllers/Site/ZixunController.php:109
        • 22. /vendor/silber/page-cache/src/Middleware/CacheResponse.php:38
        • 56. /public/index.php:53
      • select * from `new_cates` where `new_cates`.`id` in ('45') and `new_cates`.`deleted_at` is null450μs/app/Http/Controllers/Site/ZixunController.php:109zzshuju
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/Http/Controllers/Site/ZixunController.php:109
        • 27. /vendor/silber/page-cache/src/Middleware/CacheResponse.php:38
        • 61. /public/index.php:53
      • select * from `news` where `news`.`deleted_at` is null order by `browse` desc limit 10121.95ms/app/Http/Controllers/Site/ZixunController.php:110zzshuju
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/Site/ZixunController.php:110
        • 20. /vendor/silber/page-cache/src/Middleware/CacheResponse.php:38
        • 54. /public/index.php:53
      • update `news` set `browse` = `browse` + 1, `updated_at` = '2025-08-26 19:52:29' where `id` = '65992' and `news`.`deleted_at` is null8.13ms/app/Http/Model/News/News.php:170zzshuju
        Metadata
        Bindings
        • 0. 2025-08-26 19:52:29
        • 1. 65992
        Backtrace
        • 12. /app/Http/Model/News/News.php:170
        • 13. /app/Http/Controllers/Site/ZixunController.php:111
        • 21. /vendor/silber/page-cache/src/Middleware/CacheResponse.php:38
        • 55. /public/index.php:53
      • select * from `news` where `id` < '65992' and `newscate_id` = '45' and `news`.`deleted_at` is null order by `id` desc limit 1910μs/app/Http/Controllers/Site/ZixunController.php:115zzshuju
        Metadata
        Bindings
        • 0. 65992
        • 1. 45
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 13. /app/Http/Controllers/Site/ZixunController.php:115
        • 21. /vendor/silber/page-cache/src/Middleware/CacheResponse.php:38
        • 55. /public/index.php:53
      • select * from `news` where `id` > '65992' and `newscate_id` = '45' and `news`.`deleted_at` is null order by `id` asc limit 11.35ms/app/Http/Controllers/Site/ZixunController.php:116zzshuju
        Metadata
        Bindings
        • 0. 65992
        • 1. 45
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 13. /app/Http/Controllers/Site/ZixunController.php:116
        • 21. /vendor/silber/page-cache/src/Middleware/CacheResponse.php:38
        • 55. /public/index.php:53
      • select * from `comments` where `news_id` = '65992'430μs/app/Http/Controllers/Site/ZixunController.php:117zzshuju
        Metadata
        Bindings
        • 0. 65992
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/Site/ZixunController.php:117
        • 20. /vendor/silber/page-cache/src/Middleware/CacheResponse.php:38
        • 54. /public/index.php:53
        web
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
        api
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
          _token
          Oy9UHfZGCTsOVHG3p8pthxWF8FVEG2j7pnlOyRQF
          _previous
          array:1 [ "url" => "https://data.winndoo.cn/zixun/detail/65992.html" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          format
          html
          content_type
          text/html; charset=UTF-8
          status_text
          OK
          status_code
          200
          request_query
          []
          request_request
          []
          request_headers
          array:18 [ "cookie" => array:1 [ 0 => "Hm_lvt_767b4e8393ab59b402599f694cc019bd=1756209144; HMA...
          request_server
          array:42 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "HTTP_COOKIE" => "Hm_lvt_767b4e8393...
          request_cookies
          array:4 [ "Hm_lvt_767b4e8393ab59b402599f694cc019bd" => null "HMACCOUNT" => null "laravel_sessi...
          response_headers
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
          path_info
          /zixun/detail/65992.html
          session_attributes
          array:4 [ "_token" => "Oy9UHfZGCTsOVHG3p8pthxWF8FVEG2j7pnlOyRQF" "_previous" => array:1 [ "u...