Re: Improve logging when using Huge Pages

2021-11-10 Thread Masahiko Sawada
On Tue, Nov 2, 2021 at 1:24 AM Fujii Masao wrote: > > > > On 2021/10/29 7:05, Justin Pryzby wrote: > > Hi, > > > > On Wed, Oct 27, 2021 at 06:39:46AM +, Shinoda, Noriyoshi (PN Japan > > FSIP) wrote: > >> Thank you for your comment. > >> The attached patch stops message splitting. > >> This pa

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display

2021-11-10 Thread Bharath Rupireddy
On Thu, Nov 11, 2021 at 12:01 AM Bossart, Nathan wrote: > > On 11/10/21, 9:43 AM, "Bharath Rupireddy" > wrote: > > As discussed in [1], isn't it a better idea to add some of activity > > messages [2] such as recovery, archive, backup, streaming etc. to > > server logs at LOG level? They are curr

Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display

2021-11-10 Thread Bharath Rupireddy
On Thu, Nov 11, 2021 at 1:40 AM Euler Taveira wrote: > > On Wed, Nov 10, 2021, at 2:38 PM, Bharath Rupireddy wrote: > > As discussed in [1], isn't it a better idea to add some of activity > messages [2] such as recovery, archive, backup, streaming etc. to > server logs at LOG level? They are curre

Re: Weird failure in explain.out with OpenBSD

2021-11-10 Thread Mikael Kjellström
On 2021-11-11 01:15, Michael Paquier wrote: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=morepork&dt=2021-11-10%2020%3A51%3A32 Yeah, I have noticed this failure yesterday. morepork uses 6.9 now, but it has been recently upgraded from 5.4 or a version close to that, right? I am

Re: Parallel vacuum workers prevent the oldest xmin from advancing

2021-11-10 Thread Amit Kapila
On Thu, Nov 11, 2021 at 10:40 AM Masahiko Sawada wrote: > > On Thu, Nov 11, 2021 at 12:53 PM Amit Kapila wrote: > > > > On Thu, Nov 11, 2021 at 9:11 AM Andres Freund wrote: > > > > > > Hi, > > > > > > On 2021-11-11 12:22:42 +0900, Masahiko Sawada wrote: > > > > > 2. > > > > > LWLockAcquire(Pro

Re: Weird failure in explain.out with OpenBSD

2021-11-10 Thread Mikael Kjellström
On 2021-11-11 02:15, Thomas Munro wrote: On Thu, Nov 11, 2021 at 1:15 PM Michael Paquier wrote: morepork uses 6.9 now, but it has been recently upgraded from 5.4 or a version close to that, right? I am wondering if 7.0 may help regarding this issue. Postgres is not wrong here. I dunno. C

Re: Weird failure in explain.out with OpenBSD

2021-11-10 Thread Mikael Kjellström
On 2021-11-11 04:35, Andres Freund wrote: One quite conceivable way could be a VM migration. Which quite a few hosters can do behind ones back, to reduce downtimes in case of hardware maintenance etc. If openbsd is using the TSC, and something in the stack isn't quite dealing correctly with t

Re: Weird failure in explain.out with OpenBSD

2021-11-10 Thread Mikael Kjellström
On 2021-11-11 02:15, Thomas Munro wrote: I dunno. Clocks on virtualised systems and even metal seem to be a minefield of quirks and heuristics. Some discussion, may or may not be relevant: https://marc.info/?l=openbsd-tech&m=161657532610882&w=2 Just for fun I compiled and ran the test progr

Re: On login trigger: take three

2021-11-10 Thread Greg Nancarrow
On Wed, Nov 10, 2021 at 8:11 PM Daniel Gustafsson wrote: > > > If there are no objections, I plan to reinstate the previous v19 patch > > (as v21), perhaps with a few minor improvements and cleanups (e.g. SQL > > capitalization) in the tests, as hinted at in the v20 patch, but no > > new functiona

Re: Printing backtrace of postgres processes

2021-11-10 Thread vignesh C
On Wed, Nov 10, 2021 at 12:17 PM Bharath Rupireddy wrote: > > On Tue, Nov 9, 2021 at 4:45 PM vignesh C wrote: > > Thanks for reporting this, the attached v9 patch has the changes for the > > same. > > Thanks for the v9 patch. I have some comments: > > 1) I think we are moving away from if (!supe

RE: Data is copied twice when specifying both child and parent table in publication

2021-11-10 Thread houzj.f...@fujitsu.com
On Friday, November 5, 2021 11:20 AM Greg Nancarrow wrote: >On Thu, Nov 4, 2021 at 7:10 PM Amit Kapila >wrote: >> >> On Thu, Nov 4, 2021 at 12:23 PM Greg Nancarrow >> wrote: >> > >> > On Thu, Nov 4, 2021 at 3:13 PM Amit Kapila >> > <

<    1   2