Tags » PostgreSQL

LISAsoft PostgreSQL Admin Training Melbourne Monday April 27th 2015

LISAsoft is pleased to announce that PostgreSQL Administration training has been scheduled in Melbourne for the dates Monday April 27th through to Wednesday April 29th, 2015. 103 more words

Postgresql

Postgresql : To kill back end db processes

SELECT
pg_terminate_backend ( pid )
FROM
pg_stat_activity
WHERE
datname = ‘db_name’
AND pid <> pg_backend_pid ( );

Database

Postgresql 杂记

  • PG一些比较实用的聚合函数:array_agg, string_agg, bit_and/every, bit_or, bool_and, bool_or, json_agg, json_object_agg, xmlagg
  • DISCARD可以用来取消session的一些状态,例如游标、执行计划、序列的状态,临时表
  • PG的数据统计方面的能力比MySQL强不少,一方面分析函数很多,另一方面可以集成R和MADLib
  • 提高插入性能的话,可能需要在编译的时候就提高块的大小。如果记录本身很小,也就是说在一块上可以容纳很多记录,那么增加块的大小优势也不大。
  • 修改一个列的采样系数: alter table t alter column id SET STATISTICS 10000;
  • corr函数求i两个列的相关性,pg_stats.correlation的值并不是用corr计算出来的,两者之间还是有些误差
PostgreSQL

How To Install PostgreSQL 9.4 And phpPgAdmin On Ubuntu 14.10

Introduction

PostgreSQL is a powerful, open-source object-relational database system. It runs under all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS, Solaris, Tru64), and Windows OS. 830 more words

GENERAL INFO

Building GitHub projects with Jenkins, Maven and SonarQube 4.1.1 on OpenShift

Basic installation SonarQube

There are different community-driven sonar cartridges around. There is

Software Applications

How to use SQL PIVOT to Compare Two Tables in Your Database

This can happen ever so easily. You adapt a table by adding a new column:

ALTER TABLE payments ADD code NUMBER(3);

You go on, implementing your business logic – absolutely no problem. 1,007 more words

Sql

MERGE in PostgreSQL

Found cool trick how today implement Orable MERGE in PostgreSQL:

Oracle statement:

  1. MERGE INTO acme_obj_value d

  2. USING ( SELECT object_id

  3. FROM acme_state_tmp

  4. ) s

  5. ON (d.object_id = s.object_id)

163 more words
PostgreSQL