2020년 9월 14일 월요일

2020년 9월 11일 금요일

PostgreSQL Monitoring(모니터링)

 http://confluence.score/pages/viewpage.action?pageId=62984313


https://www.postgresql.org/docs/current/monitoring-stats.html


https://blog.gaerae.com/2015/09/postgresql-pg-stat-activity.html


https://www.datadoghq.com/blog/collect-postgresql-data-with-datadog/


https://www.postgresql.org/docs/current/view-pg-locks.html


https://github.com/parkbyunggyu/pbg_report/blob/master/README_KOR.txt


https://americanopeople.tistory.com/293


google : postgresql row exclusive lock


https://ktdsoss.tistory.com/257




PostgreSQL release(릴리즈), news(소식)

https://www.postgresql.org/about/newsarchive/


https://www.postgresql.org/docs/10/release.html



PostgreSQL pg_dump

작성중



 https://ktdsoss.tistory.com/251?category=544419

2020년 9월 9일 수요일

Why I picked Postgres over Oracle

작성중


https://www.enterprisedb.com/postgres-tutorials/why-i-picked-postgres-over-oracle-part-i


https://www.enterprisedb.com/postgres-tutorials/why-i-picked-postgres-over-oracle-part-ii


https://www.enterprisedb.com/postgres-tutorials/why-i-picked-postgres-over-oracle-part-iii


https://www.enterprisedb.com/blog/comparing-oracle-edb-postgres


https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative



PostgreSQL Partitioning

작성중


 https://vimeo.com/400214981


https://www.slideshare.net/EnterpriseDB/the-truth-about-partitioning?ref=


https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/database-compatibility-for-oracle-developers-guide/9.5/Database_Compatibility_for_Oracle_Developers_Guide.1.341.html



2020년 9월 7일 월요일

PostgreSQL Tuple, 성능, vacuum (1)

 작성중  



postgresql cache hit rate

 

https://ianstream.github.io/2017-11-01-Postgres-성능-이해하기

https://www.postgresql.org/docs/10/monitoring-stats.html


https://dba.stackexchange.com/questions/103421/the-cache-hit-rate-using-pg-statio-user-tables/103442


https://gist.github.com/mmattozzi/5417191


https://dbguide.tistory.com/entry/튜플Tuple-과-백쿰VACUUM

https://linux.systemv.pe.kr/튜플tuple-과-백쿰vacuum


http://boring-text.blogspot.com/2019/05/postgresql-dead-tuple.html


https://postgresql.kr/blog/postgresql_table_bloating.html


https://blog.naver.com/PostView.nhn?blogId=anytimedebug&logNo=221323992204


PostgreSQL user, role, grant

 작성중  




postgres add user to group


postgresql grant table


https://www.postgresql.org/docs/11/sql-altergroup.html


https://www.postgresql.org/docs/11/role-membership.html


https://www.postgresql.org/docs/11/sql-grant.html



2020년 9월 4일 금요일

PostgreSQL TOAST(The Oversized-Attribute Storage Technique)

 작성중  




https://data-rider.blogspot.com/2015/07/postgresql-toast.html


https://www.postgresql.org/message-id/fa0a390a-ffbd-8da9-373a-1b981063ca4d%40commandprompt.com


https://stackoverrun.com/ko/q/11562969


https://dba.stackexchange.com/questions/264691/understanding-where-pg-toast-is-coming-from


https://www.it-swarm.dev/ko/postgresql/pgtoast-%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84-%EC%B6%95%EC%86%8C%ED%95%98%EB%8A%94-%EB%B0%A9%EB%B2%95/1051689818/


http://postgresdesk.blogspot.com/p/an-example-of-getting-pgtoast.html


https://www.postgresql.org/docs/11/storage-toast.html


PostgreSQL idle_in_transaction_session_timeout

작성중  



https://www.postgresql.org/docs/9.6/runtime-config-client.html


https://postgresqlco.nf/en/doc/param/idle_in_transaction_session_timeout/





PostgreSQL temp_tablespaces

작성중 

http://blog.naver.com/geartec82/221739989660


https://postgresql.kr/docs/9.6/manage-ag-tablespaces.html


https://www.enterprisedb.com/edb-docs/d/postgresql/reference/manual/11.0/runtime-config-client.html#GUC-TEMP-TABLESPACES



https://blog.dbi-services.com/about-temp_tablespaces-in-postgresql/


https://www.postgresql.org/docs/11/manage-ag-tablespaces.html

https://stackoverflow.com/questions/16713229/postgresql-doesnt-use-temp-tablespace

https://postgresqlco.nf/en/doc/param/temp_tablespaces/



화곡 어쩌라고, 굴사냥

석화찜(굴찜)을 먹으러 여의도로 갔다 그런데 재료가 모두 소진되었다고 마감이라고 한다 응? 다들 굴에 미쳤나? 굴을 찾아 헤매다 보니, 화곡까지 가게 되었다. 화곡은 처음 가본다. 첫인상은 "술집 겁네 많네" 피똥쌀때까지 마실 수 있...