From: | Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Rick Otten <rottenwindfish(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Disk filled-up issue after a lot of inserts and drop schema |
Date: | 2016-09-14 18:00:59 |
Message-ID: | F4AC0CD0-0BCA-493F-87B0-E6AD169B4EB5@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Log rotation was active and set to 5MB or 1 day.
I don’t know if it is a bug, but Postgres was logging even if logging_collector was set to “off”.
Also, that big log file wasn’t visible for me, in fact “ls” and “du” didn’t detect it.
Thanks again
Best regards,
Pietro Pugni
> Il giorno 14 set 2016, alle ore 19:55, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> ha scritto:
>
> Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com> writes:
>> I’ve jsut discovered the issue.. I set "logging_collector=off” in the previous email but didn’t comment the other log* parameters, so Postgres was logging every single INSERT! This was caused the disk to fill up.
>
> Ah.
>
>> The strange issue is that the log file didn’t exists when the disk filled up. I personally looked for it but it wasn’t where it should have been ( /var/log/postgesql/ ), so I can’t exactly confirm that the issue was the log file getting bigger and bigger.
>
> Seems like the log file must have gotten unlinked while still active,
> or at least, *something* had an open reference to it. It's hard to
> speculate about the cause for that without more info about how you've got
> the logging set up. (Are you using the log collector? Are you rotating
> logs?) But I seriously doubt it represents a Postgres bug. Unlike the
> situation with data files, it's very hard to see how PG could be holding
> onto a reference to an unused log file. It only ever writes to one log
> file at a time.
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Knels, Udo | 2016-09-19 07:29:48 | Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher |
Previous Message | Tom Lane | 2016-09-14 17:55:51 | Re: Disk filled-up issue after a lot of inserts and drop schema |