PostgreSQL 解析ドキュメント

Size: px

Start display at page:

Download "PostgreSQL 解析ドキュメント"

えのみやのじょう
5 years ago
Views:

1 postmaster

2 Unix postmaster postmaster postmaster postmaster DB BootstrapMain() postmaster [ 2 ]

3 Unix [ 3 ]

4 Unix ( ) (SIGKILL, SIGSTOP) abort exit abort core (core dump) exit core dump ( ) [ 4 ]

5 [ 5 ]

6 PostgreSQL PostgreSQL AIGALRM SIGCHLD SIGTERM postmaster SIGINT tty (Ctrl C) SIGQUIT tty quit (Ctrl - ) SIGUSR1 postmaster SIGUSR2 postmaster [ 6 ]

7 stack stack stack heap heap heap kernel kernel kernel [ 7 ]

8 Unix read/write PostgreSQL UNIX INET IP [ 8 ]

9 socket() bind() listen() socket() accept() connect() read() write() read() write() close() close() [ 9 ]

10 accept() socket() bind() listen() accept() socket() connect() connect() accept() read()/write() [ 10 ]

11 postmaster UNIX INET (TPC/IP) select ( struct timeval * ) 0 0 NULL postmaster select select() FD_ZERO() FD_SET() [ 11 ] 1 0 XOR FD_ISSET()

12 postmaster [ 12 ]

13 ( etc...) pg_ctl check point static collector DB [ 13 ]

14 1. postmaster 2. fork backend [ 14 ]

15 ID CANCEL_REQUEST_CODE 1. postmaster 2. backendpid backend 0. backend 3. SIGINT [ 15 ]

16 postmaster [ 16 ]

17 startup, shutdown,, [ 17 ]

18 1. DB startup 2. ( ) shut down () main() PostmasterMain() DB StartUp ServerLoop() [ 18 ]

19 1. help, --version GUC DB DB 13. [ ServerLoop() ] [ 19 ]

20 [ 20 ]

21 1. --help, --version --help -? usage() ExitPostmaster(0) --version V PG_VERSION ExitPostmaster(0) 2. MemoryContextInit() (utils/mmgr) TopMemoryContext TopMemoryContext postmaster PostmasterContext PostmasterContext MemoryContextSwitchTo(PostmasterContext) [ 21 ]

22 3. GUC postmaster GUC postgres.conf GUC 4. process_preload_libraries() [ 22 ]

23 5. -S postmaster pmdaemonize() postmaster fork() postmaster postmaster stdin, stdout, stderr /dev/null 6. $PGDATA postmaster.pid postmaster [ 23 ]

24 7. TCPIP UNIX TCPIPTCPIP TCPIPpostgres.conf TCPIP TCPIP VirtualHost listen Unix JDBC TCPIP Unix /tmp 8. [ 24 ]

25 9. postmaster SIGHUP SIGHUP_handler : SIGINT, SIGQUIT, SIGTERM pmdie : postmaster SIGALRM, SIGPIPE, SIGTTIN, SIGTTOU SIG_IGN : SIGUSR1 sigusr1_handler : SIGUSR2 dummy_handler : SIGCHLD reaper : 10. postmaster/pg_stats.c statistic collector [ 25 ]

26 11. hba, ident, user, group 12. DB DB postmaster startup 13. [ ServerLoop() ] DB startup postmaster ServerLoop() startup reaper StartupPID 0 [ 26 ]

27 [ ServerLoop() ] postmaster postmaster return proc_exit() exit() return select() select() check point select() select() select() select fork() check point [ 27 ]

28 main() PostmasterMain() - pmdie() - sigusr1_handler() - reaper() ServerLoop() CheckPoint CheckPointDataBase() CheckPoint PG_SETMASK(&UnBlockSig) select() PG_SETMASK(&BlockSig) BackendStartup(port) [ 28 ]

29 7.4 DoBackend() [ 29 ]

30 PostgresMain() pg_exec_query_string () pg_parse_query () parser () yyparse () pg_analyze_and_rewrite () DML pg_plan_query () parse_analyze () transformstmt () QueryRewrite () planner () DML SQL ProcessQuery () ProcessUtility () [ 30 ] ExecutorRun () BEGIN, COMMIT, ABORT, CREATE TABLE, DROP, COPY, ALTER, GRANT, CREATE VIEW, CREATE FUNCTION, CREATE INDEX, VACUUM, Fetch, ExecuteQuery, COPY, etc...

31 fork() BackendFork() postmaster ( ) ID SIGTERM, SIGQUIT authdie : exit exit SIGALRM authdie : postmastersigalrm, SIGTERM, SIGQUIT, SIGHUP : enable_sig_alarm(authenticationtimeout * 1000, false) authdie exit : ClientAuthentication(port) exit TopMemoryContext PostmasterContext PostgresMain() exec [ 31 ]

32 BackendList ID startup, shutdown, checkpoint startup shutdown StartupPID, ShutdownPID, CheckPointPID ID BackendList postgres: stats buffer process postgres: stats collector process postmaster typedef struct bkend { pid_t pid; long cancel_key; } Backend; ServerLoop() [ 32 ]

33 DB Idempodent ( ) PostgreSQL () ( ) Write Ahead Logging [ 33 ]

34 select() checkpoint_timeout select() select() checkpoint_timeout checkpoint_timeout checkpoint_timeout checkpoint_timeout select() xlog SIGUSR1 postmaster sigusr1_hander() [ 34 ]

35 SIGCHLD postmaster reaper() ID postmasrter CheckPointPID 0 [ 35 ]

36 pg_ctl [-m smart] stop 2. backend pg_ctl 1. SIGTERM postmaster 4. backend shutdown fork 3. backend SIGCHLD backend 6. SIGCHLD shutdown 7. proc_exit() 5. DB [ 36 ]

37 pg_ctl m fast stop pg_ctl 1. SIGINT postmaster 4. backend shutdown fork 2. SIGTERM abort 3. backend SIGCHLD backend 6. SIGCHLD 7. proc_exit() shutdown 5. DB [ 37 ]

38 pg_ctl m immediate stop pg_ctl 1. SIGQUIT postmaster 2. SIGQUIT backend 3. proc_exit() SIGQUIT proc_exit() SIGKILL postmaster OS [ 38 ]

39 $ pg_ctl m f stop pg_ctl kill INT $PID kill -TERM -INT -QUIT SIGINT postmaster pmdie() Shutdown FastShutdown SignalChildren(SIGTERM); reaper() shutodown ShutdownDataBase() SIGTERM SIGCHLD fork() SIGTERM backend backend SIGCHLD reaper shutdown reaper() SIGCHLD shutdown ExitPostmaster() postmaster [ 39 ]

40 ... FatalError true reaper() reaper StartupDataBase SIGCHLD reaper() reaper() CleanupProc(pid, exitstatus); exitstatus FatalError true [ 40 ]

41 startup, shutdown, postmaster bootstrap.c BootstrapMain() BootstrapMain() stdout, stderr startup subprocess, "shutdown subprocess, "checkpoint subprocess BootstrapMain() startup x2 shutdown x4 x3 BootstrapMain() postmaster initdb postmaster boot [ 41 ]

42 startup shutdown startup StartupXLOG() StartUpID LoadFreeSpaceMap() : (7.4 ) shutdown ShutdownXLOG() CreateCheckPoint() shutdown DB_SHUTDOWNED CLOG DumpFreeSpaceMap() : (7.4 ) [ 42 ]

43 CreateDummyCaches() CreateCheckPoint(false, false) SetSavedRedoRecPtr() : postmaster REDO CreateCheckPoint() proc_exit(0) (BOOTSTRAP ) initdb postgres boot x1 BootStrapXLOG() pg_control xlog clog StartupXLOG() : [ 43 ]

44 [ 44 ]

1) // 2) I/O 3) Japan Advanced Institute of Science and Technology 2013/07/26 1

I441 2013/07/26 Dependable Network Innovation Center, Japan Advanced Institute of Science and Technology 1) // 2) I/O 3) Japan Advanced Institute of Science and Technology 2013/07/26 1 1) Comer: Internetworking