From: | Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: bug on log generation ? |
Date: | 2022-08-08 11:34:08 |
Message-ID: | CAB-JLwb4h7pQ-uoKFK-6LCHKQB_H94GGFrVHSw0HrUOgEfnL9A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
>
> How are you running postgres? If the logger process runs into trouble it
> might
> write to stderr.
>
> Is there a chance your huge statements would make you run out of space?
>
> Well, I don't think it is a out of space problem, because it
doesn´t stop logging, it just splits that message. As you can see, the next
message is logged properly. And that statement is not so huge, these
statements have not more than 10 or 20kb. And as I said these statements
occur dozens of times a day, but only once or twice is not correctly logged
An additional info, that splitted message has an out of order log time. At
that time the log file was having 2 or 3 logs per second, and that message was
1 or 2 minutes later. It seems like it occurs now but it's stored a minute
or two later.
thanks
Marcos
From | Date | Subject | |
---|---|---|---|
Next Message | Luc Vlaming Hummel | 2022-08-08 12:29:22 | Re: Reducing planning time on tables with many indexes |
Previous Message | Yuya Watari | 2022-08-08 11:27:46 | Re: [PoC] Reducing planning time when tables have many partitions |