치매 걸리기 전에 기록하자: 9월 2020

2020년 9월 14일 월요일

PostgreSQL table size, tablespace size, index size

https://korearank1.tistory.com/43

https://www.postgresdba.com/bbs/board.php?bo_table=B22&wr_id=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/