Re: Printing backtrace of postgres processes

2021-10-11 Thread bt21tanigaway
Hi, The previous patch was failing because of the recent test changes made by commit 201a76183e2 which unified new and get_new_node, attached patch has the changes to handle the changes accordingly. Thanks for your update! I have two comments. 1.Do we need “set_backtrace(NULL, 0);” on “HandleM

Re: Fix pg_log_backend_memory_contexts() 's delay

2021-10-06 Thread bt21tanigaway
Thanks for your review. Thanks for the patch. Do we also need to do the change in HandleMainLoopInterrupts, HandleCheckpointerInterrupts, HandlePgArchInterrupts, HandleWalWriterInterrupts as we don't call CHECK_FOR_INTERRUPTS() there? Yeah, that's still some information that the user asked fo

Fix pg_log_backend_memory_contexts() 's delay

2021-10-05 Thread bt21tanigaway
Hi, Log output takes time between several seconds to a few tens when using ‘SELECT pg_log_backend_memory_contexts(1234)’ with PID of ‘autovacuum launcher’. I made a patch for this problem. regards, Koyu Tanigawa diff --git a/src/backend/postmaster/autovacuum.c b/src/backend/postmaster/autovac

Re: (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented

2021-10-03 Thread bt21tanigaway
else if (Matches("LOCK", MatchAny, "IN", "ACCESS|ROW") || -Matches("LOCK", "TABLE", MatchAny, "IN", "ACCESS|ROW")) +Matches("LOCK", "TABLE", MatchAny, "IN", "ACCESS|ROW") || +Matches("LOCK", "ONLY", MatchAny, "IN", "A

Re: (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented

2021-09-28 Thread bt21tanigaway
2021-09-28 22:55 に shinya11.k...@nttdata.com さんは書きました: -Original Message- From: bt21tanigaway Sent: Tuesday, September 28, 2021 5:06 PM To: Fujii Masao ; pgsql-hackers@lists.postgresql.org Subject: Re: (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented 2021-09-28 17:03 に

Re: (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented

2021-09-28 Thread bt21tanigaway
2021-09-28 17:03 に bt21tanigaway さんは書きました: 2021-09-28 16:36 に Fujii Masao さんは書きました: On 2021/09/28 16:13, bt21tanigaway wrote: Hi, (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented in tab-complete. I made a patch for these options. Thanks for the patch! The patch seems to

Re: (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented

2021-09-28 Thread bt21tanigaway
2021-09-28 16:36 に Fujii Masao さんは書きました: On 2021/09/28 16:13, bt21tanigaway wrote: Hi, (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented in tab-complete. I made a patch for these options. Thanks for the patch! The patch seems to forget to handle the tab-completion for "

(LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented

2021-09-28 Thread bt21tanigaway
Hi, (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented in tab-complete. I made a patch for these options. regards, Koyu Tanigawa diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index 5cd5838668..12c55f5904 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/