#title PostgreSQL
[[TableOfContents]]


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

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

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

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

FDW
 * [https://www.mssqltips.com/sqlservertip/3663/sql-server-and-postgresql-foreign-data-wrapper-configuration--part-3/ SQL Server and PostgreSQL Foreign Data Wrapper Configuration]
 * [http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-writable-foreign-tables/ 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/ 설치가이드]

==== 대충 해보기 ====
 * [PostgreSQL 메모]
 * [PostgreSQL 설치]
 * [PostgreSQL 제한사항]
 * [PostgreSQL Tutorial]
 * [PostgreSQL 대충해보기]
 * [PostgreSQL 데이터액세스해보기]
 * [PostgreSQL psql 로그인]
 * [PostgreSQL 테이블만들기]
 * [PostgreSQL 트랜잭션]
 * [PostgreSQL 상속]
 * [PostgreSQL 배열]
 * [PostgreSQL postgresql.conf]
 * [http://www.postgresplus.co.kr/man/index.html PostgreSQL 8.3.3 메뉴얼]
 * attachment:PostgreSQL/postgresql_partitioning.pdf
==== ???? ====
 * GridSQL
  * attachment:PostgreSQL/GridSQLAdminGuide.PDF
  * attachment:PostgreSQL/GridSQLLoader.PDF
  * attachment:PostgreSQL/GridSQLPlanningGuide.PDF
  * attachment:PostgreSQL/GridSQLSqlReference.PDF
 * HadoopDB
  * [Up and Running with HadoopDB]
  * http://hadoopdb.sourceforge.net
  * http://hadoopdb.sourceforge.net/doc/
  * http://changyy.pixnet.net/blog/post/25623671
 * [http://www.postgresplus.co.kr/man/index.html PostgreSQL 메뉴얼] attachment:postgresplus_man.zip
 * attachment:오라클_호환성_개발자_가이드.pdf
 * 설치
  * [http://cafe.naver.com/eitlinux/45 Postgres Plus Advanced Server 설치]
  * [http://www.postgresplus.co.kr/06_postgres_lecture/gettingStart1.jsp?menu_seq=29 Install Guide]
 * 참고사항들
  * http://www.daou.co.kr/html/news_letter/22/solution_news.html
  * [http://www.postgresplus.co.kr/06_postgres_lecture/manual.jsp?menu_seq=4 메뉴얼들]
 * http://www.jopenbusiness.com/mediawiki/index.php/PostgreSQL
 * [http://pgfoundry.org/projects/bizgres/ Bizgres]
 * [http://dev.naver.com/projects/neptune Neptune]

 * LucidDB
==== Shared Nothing ====
 * [http://wiki.postgresql.org/wiki/PostgresForest PostgresForest]
 * [http://hadoopdb.sourceforge.net HadoopDB]
 * [http://www.enterprisedb.com/community/projects/gridsql.do GridSQL]
==== 참고사항 ====
 * In-Memonry
  * http://rhaas.blogspot.kr/2010/06/postgresql-as-in-memory-only-database_24.html --> PostgreSQL as an In-Memory Only Database]
  {{{fsync=off
synchronous_commit=off
full_page_writes=off
bgwriter_lru_maxpages=0
}}}
  * http://magazine.redhat.com/2007/12/12/tip-from-an-rhce-memory-storage-on-postgresql/ --> Memory storage on PostgreSQL
  * http://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing/9407940#9407940

 * http://www.commandprompt.com/ppbook/  --> Practical PostgreSQL 
 * [https://postgres.heroku.com/blog/past/2012/3/14/introducing_keyvalue_data_storage_in_heroku_postgres/ key/value data storage; hstore]
 * http://wiki.postgresql.org/wiki/Main_Page
 * http://blog.naver.com/PostList.nhn?blogId=jinukey
 * [http://www.enterprisedb.com/community/projects/gridsql.do GridSQL Project]
 * [http://pgfoundry.org/projects/dbsamples Sample Database] [attachment:dellstore2-normal-1.0.zip sampleDB-dellstore2]
 * [http://pgfoundry.org]
 * [http://coffeenix.net/doc/KoreanDoc/html/PgSQL_Extension-KLDP/PgSQL_Extension-KLDP.html#toc5 PostgreSQL 설명과 예제-주효식-]
 * [http://www.postgresql.or.kr/wiki.php/documents/PerfList PostgreSQL8.0 성능점검사항]
 * [http://techdocs.postgresql.org/oresources.php Other PostgreSQL related Resources]
 * [http://www.extendb.com ExtenDB for Data Warehousing]
 * [http://blog.naver.com/kbsps?Redirect=Log&logNo=120033062011 PostgreSQL 8.0 성능 점검 사항]
 * [http://wiki.kldp.org/KoreanDoc/html//PostgreSQLfaq_korean/PostgreSQLfaq_korean.html PostgreSQL FAQ(좀 오래되었다. 그냥 이랬었다는 것만 참고)]
 * [http://www.joinc.co.kr/modules/moniwiki/wiki.php/JCvs/Search/Document/nutch/Hadoop#s-5 Nutch Hadoop 설치 운용 문서] 
==== 도구들 ====
 * [http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools Community Guide to PostgreSQL GUI Tools]
 * http://www.squirrelsql.org/#installation
 * http://www.sql-workbench.net/getting-started.html
 * http://www.postgresql.org/about/news.1047
 * [http://www.postgresql.or.kr/wiki.php/nonun/Documents/contrib/pgbench contrib/pgbench: pgsql 벤치마크 유틸]
 * [http://www.hardgeus.com/projects/pgdesigner/ pgDesigner] attachment:pgdesigner_win_0.8.zip
==== Cheat-Sheet ====
attachment:postgresql-cheat-sheet.gif
* 참고: http://www.postgresqlguide.com/postgresql-cheat-sheet.aspx