随笔分类 -  postgresql

摘要:golang:快来抓住让我内存泄漏的“真凶”! https://mp.weixin.qq.com/s/FyHEiaa-UfyLStMKl2VFGA 原创 李卓奕 云加社区 2021-08-30 导语 | 有句话说得好:“golang10次内存泄漏,8次goroutine泄漏,1次真正内存泄漏”,那还 阅读全文
posted @ 2021-08-31 09:27 papering 阅读(1310) 评论(0) 推荐(0)
摘要:PostgreSQL: Documentation: 10: 16.4. Installation Procedure https://www.postgresql.org/docs/10/static/install-procedure.html 安装成功后 1、初始化 pg_ctl -D /us 阅读全文
posted @ 2018-08-15 21:39 papering 阅读(444) 评论(0) 推荐(0)
摘要:PostgreSQL: Documentation: 10: 1.2. Architectural Fundamentals https://www.postgresql.org/docs/10/static/tutorial-arch.html As is typical of client/se 阅读全文
posted @ 2018-08-15 19:30 papering 阅读(206) 评论(0) 推荐(0)
摘要:小结: 1、覆盖索引 回表 2、 All indexes in PostgreSQL are secondary indexes, meaning that each index is stored separately from the table's main data area (which 阅读全文
posted @ 2017-07-06 19:21 papering 阅读(355) 评论(0) 推荐(0)
摘要:sudo -u postgres createuser --superuser dbuser sudo -u postgres psql w apt install postgresql 创建视图 CREATE VIEW 类型转换 CAST 子集 全集 计数 单行显示 阅读全文
posted @ 2017-05-06 00:41 papering 阅读(369) 评论(0) 推荐(0)