Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit0843ec0

Browse files
committed
Add "idle in transaction" status message
1 parent87070cc commit0843ec0

File tree

2 files changed

+181
-3
lines changed

2 files changed

+181
-3
lines changed

‎src/backend/tcop/postgres.c

Lines changed: 5 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
*
99
*
1010
* IDENTIFICATION
11-
* $Header: /cvsroot/pgsql/src/backend/tcop/postgres.c,v 1.204 2001/01/2414:32:32 momjian Exp $
11+
* $Header: /cvsroot/pgsql/src/backend/tcop/postgres.c,v 1.205 2001/01/2415:53:59 momjian Exp $
1212
*
1313
* NOTES
1414
* this is the "main" module of the postgres backend and
@@ -1680,7 +1680,7 @@ PostgresMain(int argc, char *argv[], int real_argc, char *real_argv[], const cha
16801680
if (!IsUnderPostmaster)
16811681
{
16821682
puts("\nPOSTGRES backend interactive interface ");
1683-
puts("$Revision: 1.204 $ $Date: 2001/01/2414:32:32 $\n");
1683+
puts("$Revision: 1.205 $ $Date: 2001/01/2415:53:59 $\n");
16841684
}
16851685

16861686
/*
@@ -1791,7 +1791,9 @@ PostgresMain(int argc, char *argv[], int real_argc, char *real_argv[], const cha
17911791

17921792
EnableNotifyInterrupt();
17931793

1794-
set_ps_display("idle");
1794+
if (!IsTransactionBlock())
1795+
set_ps_display("idle");
1796+
elseset_ps_display("idle in transaction");
17951797

17961798
/* Allow "die" interrupt to be processed while waiting */
17971799
ImmediateInterruptOK= true;

‎src/backend/utils/misc/postgresql.conf.sample

Lines changed: 176 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -18,3 +18,179 @@
1818
# Any option can also be given as a command line switch to the
1919
# postmaster, e.g., 'postmaster -c log_connections=on'. Some options
2020
# can be set at run-time with the 'SET' SQL command.
21+
22+
23+
enable_seqscan = true
24+
enable_indexscan = true
25+
enable_tidscan = true
26+
enable_sort = true
27+
enable_nestloop = true
28+
enable_mergejoin = true
29+
enable_hashjoin = true
30+
31+
ksqo = izer, false
32+
geqo = true
33+
34+
tcpip_socket = false
35+
ssl = false
36+
fsync = true
37+
silent_mode = false
38+
39+
log_connections = false
40+
log_timestamp = false
41+
log_pid = false
42+
43+
#ifdef USE_ASSERT_CHECKING
44+
debug_assertions = true
45+
#endif
46+
47+
debug_print_query = false
48+
debug_print_parse = false
49+
debug_print_rewritten = false
50+
debug_print_plan = false
51+
debug_pretty_print = false
52+
53+
show_parser_stats = false
54+
show_planner_stats = false
55+
show_executor_stats = false
56+
show_query_stats = false
57+
#ifdef BTREE_BUILD_STATS
58+
show_btree_build_stats = false
59+
#endif
60+
61+
trace_notify = false
62+
63+
#ifdef LOCK_DEBUG
64+
trace_locks = false
65+
trace_userlocks = false
66+
trace_spinlocks = false
67+
debug_deadlocks = false
68+
#endif
69+
70+
hostname_lookup = false
71+
show_source_port = false
72+
73+
sql_inheritance = true
74+
75+
{NULL, 0, NULL, false}
76+
};
77+
78+
79+
static struct config_int
80+
ConfigureNamesInt[] =
81+
{
82+
geqo_threshold = PGC_USERSET, &geqo_rels,
83+
DEFAULT_GEQO_RELS, 2, INT_MAX
84+
geqo_pool_size = PGC_USERSET, &Geqo_pool_size,
85+
DEFAULT_GEQO_POOL_SIZE, 0, MAX_GEQO_POOL_SIZE
86+
geqo_effort = PGC_USERSET, &Geqo_effort,
87+
1, 1, INT_MAX
88+
geqo_generations = PGC_USERSET, &Geqo_generations,
89+
0, 0, INT_MAX
90+
geqo_random_seed = PGC_USERSET, &Geqo_random_seed,
91+
-1, INT_MIN, INT_MAX
92+
93+
deadlock_timeout = PGC_POSTMASTER, &DeadlockTimeout,
94+
1000, 0, INT_MAX
95+
96+
#ifdef ENABLE_SYSLOG
97+
syslog = PGC_SIGHUP, &Use_syslog,
98+
0, 0, 2
99+
#endif
100+
101+
/*
102+
* Note: There is some postprocessing done in PostmasterMain() to
103+
* make sure the buffers are at least twice the number of
104+
* backends, so the constraints here are partially unused.
105+
*/
106+
max_connections = PGC_POSTMASTER, &MaxBackends,
107+
DEF_MAXBACKENDS, 1, MAXBACKENDS
108+
shared_buffers = PGC_POSTMASTER, &NBuffers,
109+
DEF_NBUFFERS, 16, INT_MAX
110+
port = PGC_POSTMASTER, &PostPortNumber,
111+
DEF_PGPORT, 1, 65535
112+
113+
sort_mem = PGC_USERSET, &SortMem,
114+
512, 1, INT_MAX
115+
116+
debug_level = PGC_USERSET, &DebugLvl,
117+
0, 0, 16
118+
119+
#ifdef LOCK_DEBUG
120+
trace_lock_oidmin = PGC_SUSET, &Trace_lock_oidmin,
121+
BootstrapObjectIdData, 1, INT_MAX
122+
trace_lock_table = PGC_SUSET, &Trace_lock_table,
123+
0, 0, INT_MAX
124+
#endif
125+
max_expr_depth = PGC_USERSET, &max_expr_depth,
126+
DEFAULT_MAX_EXPR_DEPTH, 10, INT_MAX
127+
128+
unix_socket_permissions = PGC_POSTMASTER, &Unix_socket_permissions,
129+
0777, 0000, 0777
130+
131+
checkpoint_timeout",PGC_POSTMASTER,&CheckPointTimeout,
132+
300, 30, 1800
133+
134+
wal_buffers",PGC_POSTMASTER,&XLOGbuffers,
135+
8, 4, INT_MAX
136+
137+
wal_files",PGC_POSTMASTER,&XLOGfiles,
138+
0, 0, 64
139+
140+
wal_debug",PGC_SUSET,&XLOG_DEBUG,
141+
0, 0, 16
142+
143+
commit_delay",PGC_USERSET,&CommitDelay,
144+
5, 0, 1000
145+
146+
{NULL, 0, NULL, 0, 0, 0}
147+
};
148+
149+
150+
static struct config_real
151+
ConfigureNamesReal[] =
152+
{
153+
effective_cache_size = PGC_USERSET, &effective_cache_size,
154+
DEFAULT_EFFECTIVE_CACHE_SIZE, 0, DBL_MAX
155+
random_page_cost = PGC_USERSET, &random_page_cost,
156+
DEFAULT_RANDOM_PAGE_COST, 0, DBL_MAX
157+
cpu_tuple_cost = PGC_USERSET, &cpu_tuple_cost,
158+
DEFAULT_CPU_TUPLE_COST, 0, DBL_MAX
159+
cpu_index_tuple_cost = PGC_USERSET, &cpu_index_tuple_cost,
160+
DEFAULT_CPU_INDEX_TUPLE_COST, 0, DBL_MAX
161+
cpu_operator_cost = PGC_USERSET, &cpu_operator_cost,
162+
DEFAULT_CPU_OPERATOR_COST, 0, DBL_MAX
163+
164+
geqo_selection_bias = PGC_USERSET, &Geqo_selection_bias,
165+
DEFAULT_GEQO_SELECTION_BIAS, MIN_GEQO_SELECTION_BIAS, MAX_GEQO_SELECTION_BIAS
166+
167+
{NULL, 0, NULL, 0.0, 0.0, 0.0}
168+
};
169+
170+
171+
static struct config_string
172+
ConfigureNamesString[] =
173+
{
174+
krb_server_keyfile = PGC_POSTMASTER, &pg_krb_server_keyfile,
175+
PG_KRB_SRVTAB, NULL
176+
177+
unix_socket_group = PGC_POSTMASTER, &Unix_socket_group,
178+
" = NULL
179+
180+
#ifdef ENABLE_SYSLOG
181+
syslog_facility = PGC_POSTMASTER, &Syslog_facility,
182+
"LOCAL0 = check_facility
183+
syslog_ident = PGC_POSTMASTER, &Syslog_ident,
184+
"postgres = NULL
185+
#endif
186+
187+
unix_socket_directory", PGC_POSTMASTER, &UnixSocketDir,
188+
" = NULL
189+
190+
virtual_host", PGC_POSTMASTER,&VirtualHost,
191+
" = NULL
192+
193+
{NULL, 0, NULL, NULL, NULL}
194+
};
195+
196+

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp