摘要: http://blog.csdn.net/hantiannan/article/details/4517192http://www.cnblogs.com/gaojian/archive/2012/11/08/2759874.htmlhttp://m.oschina.net/blog/135872h... 阅读全文
posted @ 2014-05-30 17:33 bielidefeng 阅读(328) 评论(0) 推荐(0)
摘要: ubuntu追加空间http://blog.csdn.net/openme_openwrt/article/details/8099956-------------------播放视频avi等使用SMPLAYER播放器-----------终端目录的说明使用“/usr/.....”===>系统目录... 阅读全文
posted @ 2014-05-30 11:05 bielidefeng 阅读(457) 评论(0) 推荐(0)
摘要: ----------ps -ewf显示所有进程,ps -a|grep ss指的是显示ss关键字的所有进程。top是动态显示进程。---------cat直接将文件内容显示在终端上。 ---------查看linux系统版本信息cat /etc/*release。---------从一台Linux机子... 阅读全文
posted @ 2014-05-30 11:04 bielidefeng 阅读(289) 评论(0) 推荐(0)
摘要: http://docs.oracle.com/cd/E19253-01/819-6951/index.htmlhttp://lovesoo.org/linux-sar-command-detailed.htmlhttp://www.live-in.org/archives/922.htmlfree:... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(308) 评论(0) 推荐(0)
摘要: postgresql利用归档文件恢复:http://bbs.chinaunix.net/thread-1771360-1-1.html http://blog.163.com/digoal@126/blog/static/16387704020110442050808/ master:ip:127... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(167) 评论(0) 推荐(0)
摘要: alter一个表的列的时候会出现rewrites表:比如添加一个有默认值的新列会rewrites重写表(即先vacuum full此表):http://my.oschina.net/Kenyon/blog/99757ctid来查看有默认值的新列:digoal=# select ctid,* from... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(190) 评论(0) 推荐(0)
摘要: http://www.postgresql.org/docs/9.3/static/functions-comparisons.html#AEN18448Row-wise Comparison:row的定义:http://www.postgresql.org/docs/9.3/static/sql-... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(192) 评论(0) 推荐(0)
摘要: http://www.postgresql.org/docs/9.3/static/functions-admin.htmlGeneric File Access Functions:普通文件的访问方法:digoal=# select pg_ls_dir('.'); pg_ls_dir ... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(191) 评论(0) 推荐(0)
摘要: 继承:http://www.postgresql.org/docs/9.3/static/ddl-inherit.html分区表:http://www.postgresql.org/docs/9.3/static/ddl-partitioning.html分区表需要和trigger一起使用才可。CR... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(98) 评论(0) 推荐(0)
摘要: Postgres-XC:http://blog.csdn.net/huguangshanse00/article/details/9636621http://blog.163.com/digoal@126/blog/static/1638770402013332335933/http://blog.... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(131) 评论(0) 推荐(0)