type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connec- 1. http://lwn.net/Articles/104179/ data directory is shut down. Three different shutdown methods can be selected with the -m option: “Smart” mode waits for online backup mode to finish and all the clients to disconnect. This is the default file from other users is disallowed by default. -m mode Specifies the shutdown mode. mode can be smart, fast, or immediate, or the first letter of one of these three. -o options Specifies options to

type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connections, but lets existing sessions data directory is shut down. Three different shutdown methods can be selected with the -m option: “Smart” mode waits for online backup mode to finish and all the clients to disconnect. This is the default file from other users is disallowed by default. -m mode Specifies the shutdown mode. mode can be smart, fast, or immediate, or the first letter of one of these three. -o options Specifies options to

type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connections, but lets existing sessions allows a superuser to connect to terminate online backup mode). If the server is in recovery when a smart shutdown is requested, recovery and streaming replication will be stopped only after all regular sessions data directory is shut down. Three different shutdown methods can be selected with the -m option: “Smart” mode waits for online backup mode to finish and all the clients to disconnect. This is the default

type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connec- tions, but lets existing allows a superuser to connect to terminate online backup mode). If the server is in recovery when a smart shutdown is requested, recovery and streaming replication will be stopped only after all regular sessions data directory is shut down. Three different shutdown methods can be selected with the -m option: “Smart” mode waits for online backup mode to finish and all the clients to disconnect. This is the default

attractive if f() is an expensive-to-compute function. However, PostgreSQL's planner is currently not very smart about such cases. It considers a query to be potentially executable by index-only scan only when all type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connections, but lets existing sessions allows a superuser to connect to terminate online backup mode). If the server is in recovery when a smart shutdown is requested, recovery and streaming replication will be stopped only after all regular sessions

attractive if f() is an expensive-to-compute function. However, PostgreSQL's planner is currently not very smart about such cases. It considers a query to be potentially executable by index-only scan only when all type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connec- tions, but lets existing allows a superuser to connect to terminate online backup mode). If the server is in recovery when a smart shutdown is requested, recovery and streaming replication will be stopped only after all regular sessions

type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connec- tions, but lets existing allows a superuser to connect to terminate online backup mode). If the server is in recovery when a smart shutdown is requested, recovery and streaming replication will be stopped only after all regular sessions data directory is shut down. Three different shutdown methods can be selected with the -m option. “Smart” mode (the default) waits for all active clients to disconnect and any online backup to finish. If

type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connections, but lets existing sessions allows a superuser to connect to terminate online backup mode). If the server is in recovery when a smart shutdown is requested, recovery and streaming replication will be stopped only after all regular sessions data directory is shut down. Three different shutdown methods can be selected with the -m option. “Smart” mode (the default) waits for all active clients to disconnect and any online backup to finish. If

attractive if f() is an expensive-to-compute function. However, PostgreSQL’s planner is currently not very smart about such cases. It considers a query to be potentially executable by index-only scan only when all type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connections, but lets existing sessions allows a superuser to connect to terminate online backup mode). If the server is in recovery when a smart shutdown is requested, recovery and streaming replication will be stopped only after all regular sessions

if f() is an expensive-to-compute function. How- ever, PostgreSQL’s planner is currently not very smart about such cases. It considers a query to be potentially executable by index-only scan only when all type of shutdown by sending different signals to the master postgres process. SIGTERM This is the Smart Shutdown mode. After receiving SIGTERM, the server disallows new connec- tions, but lets existing allows a superuser to connect to terminate online backup mode). If the server is in recovery when a smart shutdown is requested, recovery and streaming replication will be stopped only after all regular sessions