search

chapter_11

PostgreSQL ์„ฑ๋Šฅ ์ง€ํ‘œ ์ดํ•ดchevron-rightEXPLAIN๊ณผ EXPLAIN ANALYZE ํ™œ์šฉchevron-right์‹คํ–‰ ๊ณ„ํš(Execution Plan) ํ•ด์„๋ฒ•chevron-right์ธ๋ฑ์Šค ํŠœ๋‹(B-Tree, Hash, GIN, GiST ๋“ฑ)chevron-rightํ†ต๊ณ„ ์ˆ˜์ง‘ ์‹œ์Šคํ…œ(Autovacuum, pg_stat*)chevron-rightVACUUM๊ณผ AUTOVACUUM ์„ธ๋ถ€ ์„ค์ •chevron-rightํŒŒ๋ผ๋ฏธํ„ฐ ํŠœ๋‹(Work_mem, Shared_buffers ๋“ฑ)chevron-right๋ณ‘๋ ฌ ์ฟผ๋ฆฌ(Parallel Query) ์„ค์ •chevron-right๋กœ๊น… ๋ฐ ๋””๋ฒ„๊น… ์„ค์ •chevron-right์‹ค๋ฌด ์„ฑ๋Šฅ ํ…Œ์ŠคํŠธ์™€ ๋ฒค์น˜๋งˆํฌ ๊ธฐ๋ฒ•chevron-right
Previous์ตœ์‹  ๋ฒ„์ „์—์„œ์˜ MVCC ๊ฐœ์„ ์ NextPostgreSQL ์„ฑ๋Šฅ ์ง€ํ‘œ ์ดํ•ด

Last updated