http://200yi.com/ff_internal/ 2026-04-28T01:14:53+0800 http://200yi.com/ff_internal/ http://200yi.com/ff_internal/lib/tpl/mnml-blog/images/favicon.ico text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:misc:Transparent%20Huge%20Pages%E5%AF%B9%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E5%BD%B1%E5%93%8D&rev=1687008318&do=diff Transparent Huge Pages（THP)，本来是Linux为提高系统性能而做的努力，结果反而成了性能的隐患。一些主流数据库在官方文档都建议禁用该功能。 一、Greenplum Database(GPDB) "Disable Transparent Huge Pages (THP) as it degrades Greenplum Database performance. text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:misc:%E6%95%B0%E6%8D%AE%E5%BA%93%E8%83%8C%E6%99%AF%E7%9F%A5%E8%AF%86%E9%9B%86%E9%94%A6&rev=1687008318&do=diff 一、SQL语法 * SQL教程 * OLAP函数语法的总结 * OVER(PARTITION BY)函数介绍 二、并发 * 什么是乐观锁，什么是悲观锁 * sql中的for update是什么？ 三、术语 RTO (Recovery Time Objective，参考：数仓集群管理：单节点故障RTO机制分析 text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:misc:%E6%95%B0%E6%8D%AE%E5%BA%93%E5%A4%9A%E7%A7%9F%E6%88%B7%E5%88%86%E7%BA%A7%E8%B5%84%E6%BA%90%E7%AE%A1%E7%90%86&rev=1687008318&do=diff 参考 * 企业服务的“多租户多层级”模式 * GaussDB(DWS) 资源管理技术浅析 text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:misc:%E5%9C%A8%E7%BA%BF%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93SQL%E7%BB%83%E4%B9%A0%E7%8E%AF%E5%A2%83&rev=1687008318&do=diff Oracle Live * https://livesql.oracle.com dbfiddle * https://dbfiddle.uk sqlfiddle * http://sqlfiddle.com