개발

• PostgreSQL Reference
  
• PostgreSQL JSON
  
• PostgreSQL as NoSQL with Data Validation(http://blog.endpoint.com/2013/06/postgresql-as-nosql-with-data-validation.html)
  
• How do I modify fields inside the new PostgreSQL JSON datatype?(http://stackoverflow.com/questions/18209625/how-do-i-modify-fields-inside-the-new-postgresql-json-datatype)
  
• PostgreSQL SQL Tricks(http://postgres.cz/wiki/PostgreSQL_SQL_Tricks) --> 20151021백업본
  
• PL/pgSQL Tutorial(http://www.w3resource.com/PostgreSQL/pl-pgsql-tutorial.php)
  
• http://postgres.cz/wiki/PL/pgSQL_(en)
  
• Command execution with a PostgreSQL UDF(http://bernardodamele.blogspot.kr/2009/01/command-execution-with-postgresql-udf.html)
  
• PostgreSQL Partitioning
  
• tool --> http://squirrel-sql.sourceforge.net/
  
• time zone
  
• BRIN 인덱스(http://bitnine.tistory.com/66)
  
  

구축

• streaming replication
  
• pgbouncer
  
• PostgresSQL ODBC Driver Download(http://www.postgresql.org/ftp/odbc/versions/msi/)
  
• Simple Streaming replication setting with pgpool-II(http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/)
  
• pgtune web site(http://pgtune.leopard.in.ua/) pgtune example
  
• Replication Manager for PostgreSQL clusters(http://www.repmgr.org/)
  
  

pbBouncer(https://pgbouncer.github.io/)

• Using the PgBouncer Connection Pooler(http://gpdb.docs.pivotal.io/4360/admin_guide/access_db/topics/pgbouncer.html)
  
• How to Set Up PgBouncer Connection Pooling for Postgres Plus Standard Server
  
• Setup pgbouncer connection pooling for PostgreSQL on CentOS/RedHat/Fedora(https://opensourcedbms.com/dbms/setup-pgbouncer-connection-pooling-for-postgresql-on-centosredhatfedora/)
  
• PostgreSQL High Availability/Scalability using HAProxy and PGBouncer(http://dba.stackexchange.com/questions/56559/postgresql-high-availability-scalability-using-haproxy-and-pgbouncer?rq=1)
  
  

pg_kafka(https://github.com/xstevens/pg_kafka)
PL/Proxy(https://plproxy.github.io/)
pgHA(https://bitbucket.org/openscg/pgha/)

FDW

• SQL Server and PostgreSQL Foreign Data Wrapper Configuration(https://www.mssqltips.com/sqlservertip/3663/sql-server-and-postgresql-foreign-data-wrapper-configuration--part-3/)
  
• Postgres 9.3 feature highlight: writable foreign tables(http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-writable-foreign-tables/)
  
  

링크들

• http://postgresql.kr/
  
• http://blog.naver.com/PostList.nhn?blogId=hdlee91&from=postList&categoryNo=34
  
• http://wiki.postgresql.org/wiki/Sample_Databases
  
  

Greeanplum

• http://greenplum.org/
  
• http://pivotal.io/big-data/pivotal-greenplum-database
  
• 설치가이드(https://pivotalkr.wordpress.com/2015/02/09/greenplum-%EC%84%A4%EC%B9%98-%EA%B0%80%EC%9D%B4%EB%93%9C-4-node-vm/)
  
  

1 대충 해보기 #

2 ???? #

3 Shared Nothing #

4 참고사항 #

5 도구들 #

6 Cheat-Sheet #