PostgreSQL 8.3.3¹®¼
Prev
Fast Backward
Fast Forward
Next
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.
Çà ÃßÁ¤ÀÇ ¿¹
Prev
Home
Next
postmaster
PostgreSQL ³»ºÎÀÇ °³¿ä