VII. ³»ºÎ Á¤º¸

¿©±â¿¡¼­´Â, PostgreSQL °³¹ßÀÚ°¡ »ç¿ëÇÒ ¼ö ÀÖ´Â Á¤º¸¸¦ ºÐ·ùÇØ ¼³¸íÇÕ´Ï´Ù.

Table of Contents
42. PostgreSQL ³»ºÎÀÇ °³¿ä
42.1. Äõ¸®ÀÇ °æ·Î
42.2. Á¢¼ÓÀ» ¾î¶»°Ô È®¸³Çϴ°¡
42.3. ÆÄ½Ì(parser) ´Ü°è
42.4. PostgreSQL·ê ½Ã½ºÅÛ
42.5. planner/¿ÉƼ¸¶ÀÌÀú
42.6. ¼öÇàÀÚ(Executor)
43. ½Ã½ºÅÛ Ä«Å»·Î±×
43.1. °³¿ä
43.2. pg_aggregate
43.3. pg_am
43.4. pg_amop
43.5. pg_amproc
43.6. pg_attrdef
43.7. pg_attribute
43.8. pg_authid
43.9. pg_auth_members
43.10. pg_autovacuum
43.11. pg_cast
43.12. pg_class
43.13. pg_constraint
43.14. pg_conversion
43.15. pg_database
43.16. pg_depend
43.17. pg_description
43.18. pg_index
43.19. pg_inherits
43.20. pg_language
43.21. pg_largeobject
43.22. pg_listener
43.23. pg_namespace
43.24. pg_opclass
43.25. pg_operator
43.26. pg_pltemplate
43.27. pg_proc
43.28. pg_rewrite
43.29. pg_shdepend
43.30. pg_shdescription
43.31. pg_statistic
43.32. pg_tablespace
43.33. pg_trigger
43.34. pg_type
43.35. ½Ã½ºÅÛºä
43.36. pg_cursors
43.37. pg_group
43.38. pg_indexes
43.39. pg_locks
43.40. pg_prepared_statements
43.41. pg_prepared_xacts
43.42. pg_roles
43.43. pg_rules
43.44. pg_settings
43.45. pg_shadow
43.46. pg_stats
43.47. pg_tables
43.48. pg_timezone_abbrevs
43.49. pg_timezone_names
43.50. pg_user
43.51. pg_views
44. ÇÁ·ÐÆ®¿£µå/¿¬±¸ ÃÖÁ¾ ´Ü°è ÇÁ·ÎÅäÄÝ
44.1. °³¿ä
44.2. ¸Þ¼¼ÁöÀÇ È帧
44.3. ¸Þ¼¼ÁöÀÇ µ¥ÀÌÅÍÇü
44.4. ¸Þ¼¼ÁöÀÇ Çü½Ä
44.5. ¿¡·¯ ¹× °æº¸ ¸Þ¼¼Áö Çʵå
44.6. ÇÁ·ÎÅäÄÝ 2.0À¸·ÎºÎÅÍÀÇ º¯°æÁ¡ÀÇ ¿ä¾à
45. PostgreSQL ÄÚµù ±Ô¾à
45.1. ¼­½Ä
45.2. ¼­¹ö ³»ºÎ·ÎºÎÅÍÀÇ ¿¡·¯ÀÇ º¸°í
45.3. ¿¡·¯ ¸Þ¼¼Áö ¾ç½Ä°¡À̵å
46. ¸ð±¹¾î Áö¿ø
46.1. ¹ø¿ªÀÚ¿¡°Ô
46.2. ÇÁ·Î±×·¡¸Ó¿¡°Ô
47. ÀýÂ÷¾ð¾î Çڵ鷯 ÀÛ¼º
48. À¯ÀüÀû Äõ¸® ÃÖÀûÈ­
48.1. º¹ÀâÇÑ ÃÖÀûÈ­ ¹®Á¦·Î¼­ÀÇ Äõ¸® ó¸®
48.2. À¯ÀüÀû ¾Ë°í¸®Áò
48.3. PostgreSQLÀÇ À¯ÀüÀû ¹®ÀÇ ÃÖÀûÈ­(GEQO)
48.4. Ãß°¡ Á¤º¸
49. À妽º ¾×¼¼½º ¸Þ¼Òµå ÀÎÅÍÆäÀ̽º Á¤ÀÇ
49.1. À妽º¸¦ À§ÇÑ Ä«Å»·Î±× Ç׸ñ
49.2. À妽º ¾×¼¼½º ¸Þ¼Òµå ÇÔ¼ö
49.3. À妽º ½ºÄµ
49.4. À妽ºÀÇ ¶ô(locking) °ËÅä
49.5. À妽º À¯Àϼº °Ë»ç
49.6. À妽º ÄÚ½ºÆ® ÃßÁ¤ ÇÔ¼ö
50. GiST À妽º
50.1. ¼­·Ð
50.2. È®Àå °¡´É¼º
50.3. ½ÇÇà
50.4. Examples
50.5. ¿À·ù º¹±¸
51. GIN À妽º
51.1. ¼Ò°³
51.2. È®Àå °¡´É¼º
51.3. ½ÇÇà
51.4. GIN ÆÁ°ú Æ®¸¯
51.5. Á¦ÇÑ
51.6. Examples
52. µ¥ÀÌÅͺ£À̽ºÀÇ ¹°¸®ÀûÀÎ ÀúÀåÀåÄ¡
52.1. µ¥ÀÌÅͺ£À̽º ÆÄÀÏÀÇ ·¹À̾ƿô
52.2. TOAST
52.3. µ¥ÀÌÅͺ£À̽º ÆäÀÌÁö ·¹À̾ƿô
53. BKI¹é¿£µå(Backend) ÀÎÅÍÆäÀ̽º
53.1. BKI ÆÄÀÏ Çü½Ä
53.2. BKI Ä¿¸Çµå
53.3. BKIÆÄÀÏÀÇ bootstrapÀÇ ±¸Á¶
53.4. ¿¹Á¦
54. planner°¡ Åë°è Á¤º¸¸¦ ¾î¶»°Ô »ç¿ëÇÒ±î
54.1. Çà ÃßÁ¤ÀÇ ¿¹