过滤Unicode字符 sed -i 's/\u0000//g' json.txt 使用pgfutter Github pgfutter pgfutter --jsonb json

pom.xml <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.*</include> <include>**/*</include> </includes> <filtering>true</filtering> </resource> </resources> <plugins>

analyze 作用： > 分析表主要作用是分析并保存索引的分布. analyze-table MySQL document 语法:

初始化示例数据库 ┌─[sky@sky-linux] - [/ihome/db/postgresql] - [2016-09-19 03:22:35]

Redis中缓存策略 volatile-lru：从数据集中，将

Redis 引发系统OOM Killer 昨晚（2016-9-5），生产环境的Red

目标 番茄工作法是一套简单的工具和流程，用以提升你个人和所在团

查看是否存在无效索引 SELECT * FROM pg_class, pg_index WHERE pg_index.indisvalid = false AND pg_index.indexrelid = pg_class.oid; 查看大小 查看表

版本 PostgreSQL [local]:5432 sky@sky=# select version(); version ----------------------------------------------------------------------------------------------------------- PostgreSQL 9.6beta4 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bit (1 row) Time: 0.407 ms [local]:5432 sky@sky=# MySQL mysql> select

PostgreSQL添加字段对表的影响 [local]:5432 sky@sky=# select pg_relation_filepath('testcount'); pg_relation_filepath ---------------------- base/16384/18081 (1 row) Time: 0.163

因为平时工作中要经常打开多个窗口，然后SSH登录服务器。最后

PostgreSQL获取部分结果集中再获取最大值最小值的结果

并行查询 这个是PostgreSQL 9.6才开始有的。 测试环境

~/.psqlrc 内容如下: -- Found this on thoughtbot here: -- https://robots.thoughtbot.com/improving-the-command-line-postgres-experience -- and it fixes problems with psql, some I didn't even know I had. -- --

内存相关 shared_buffers 这个参数决定了有多少内存将用于PostgreSQL