Pg
文章平均质量分 72
say_again
这个作者很懒,什么都没留下…
展开
-
BenchmarkSQL安装使用介绍
BenchmarkSQL安装使用介绍 --连顺科 2014/05/13一、简介An easy to use JDBC benchmark that closely resembles the TPC-C standard for OLTP. RDBMS's presently supported include PostgreSQL, EnterpriseDB and原创 2014-07-07 16:48:13 · 3994 阅读 · 0 评论 -
pg_bulkload批量载入工具(初探)
安装:# tar -zxvf pg_bulkload-3.1.6.tar.gz# cd pg_bulkload-3.1.6# . /home/postgres/.bash_profile# make# make install引入扩展:$ psql psql (9.3.4)Type "help" for help.postgres=# create原创 2014-09-01 15:07:49 · 3114 阅读 · 0 评论 -
pgpool-II+Hot_standby+Streaming replication环境搭建
1、实验环境说明1.1 操作系统1. # cat /etc/issue1) CentOS release 5.5 (Final)2) Kernel \r on an \m 2. # uname -a1) Linux pgpool 2.6.18-194.el5 #1 SMP Fri Apr 2 14:58:原创 2014-09-01 17:18:59 · 1624 阅读 · 0 评论 -
PostgreSQL data同步工具【pg_rewind】
pg_rewind is a tool for synchronizing a PostgreSQL data directory with another PostgreSQL data directory that was forked from the first one. The result is equivalent to rsyncing the first data directory with the second one. The advantage of pg_rewind over原创 2014-09-01 16:59:17 · 4192 阅读 · 0 评论 -
Ora2Pg安装配置
说明该文档为简单的Ora2Pg安装配置使用说明文档,主要涵盖安装前其它组件的安装、Ora2Pg安装、配置以及利用Ora2Pg从Oracle生成sql脚本,利用sql脚本导入PostgreSQL数据库中。Ora2Pg是以perl开发的perl模块工具,为使安装能够顺利通过,在安装Ora2Pg之前必须先确保系统已经安装了perl模块以及DBI、DBD::Oracle模块。若需要直接导入原创 2014-09-01 15:22:00 · 7349 阅读 · 0 评论 -
PITRTools
pitrtools is a Python + PostgreSQL application that assists in the provisioning of Hot Standby, Warm Standby, Cold Standby, Streaming Replication clusters and multiple standbys (slaves). It supp原创 2014-09-01 14:33:53 · 530 阅读 · 0 评论 -
pgsi
一、简介pgsi is the Postgres System Impact report,a script that analyzes Postgres log files and reports on which queries have thehighest overall impact on the server. The impact is computed by原创 2014-09-01 14:36:59 · 8264 阅读 · 0 评论 -
TPC-H Benchmark
关于TCP-H benchmarkThe TPC-H Benchmark is a popular one for comparing database vendors. It's possible to run the TPC-H data set on PostgreSQL without having a formal testing kit (although there is D原创 2014-09-01 13:50:49 · 1758 阅读 · 0 评论 -
check_postgres脚本集
一、简介check_postgres is a script for monitoring various attributes of your database. It is designed to work with Nagios, MRTG, or in standalone scripts. 二、安装2.1 编译安装[root@check_postgres ~]原创 2014-09-01 15:30:12 · 1025 阅读 · 0 评论 -
Postgres-XL测试
GTM-Proxy的作用:GTM-Proxy is not a mandatory component of Postgres-XL cluster but it can be used to group messages between GTM and cluster nodes, reducing workload and the number of packages ex原创 2014-09-01 14:24:46 · 5099 阅读 · 2 评论 -
PostgreSQL对象重组工具【pg_reorg】
Description:pg_reorg is an utility program toreorganize tables in PostgreSQL databases. Unlike clusterdb, it doesn't blockany selections and updates during reorganization. You can choose o原创 2014-09-01 16:38:17 · 1944 阅读 · 0 评论