Am Dienstag, 29. März 2005 16:37 schrieb Tom Lane:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > Am Montag, 28. März 2005 18:06 schrieb Tom Lane:
> >> The only way for pg_xlog to bloat vastly beyond what it's supposed to be
> >> (which is to say, about twice your checkpoint_segments setting) is i
Janning Vygen <[EMAIL PROTECTED]> writes:
> Am Montag, 28. März 2005 18:06 schrieb Tom Lane:
>> The only way for pg_xlog to bloat vastly beyond what it's supposed to be
>> (which is to say, about twice your checkpoint_segments setting) is if
>> checkpoints are somehow blocked from happening. The o
Am Montag, 28. März 2005 18:06 schrieb Tom Lane:
> "Janning Vygen" <[EMAIL PROTECTED]> writes:
> > My disk was running full with 100 GB (!) of data/pg_xlog/ files.
>
> The only way for pg_xlog to bloat vastly beyond what it's supposed to be
> (which is to say, about twice your checkpoint_segments s
aestrutura e Banco de Dados
> Planae Tecnologia da Informação
> (+55) 14 2106-3514
> http://www.planae.com.br
> - Original Message -
> From: "Janning Vygen" <[EMAIL PROTECTED]>
> To:
> Sent: Monday, March 28, 2005 7:19 AM
> Subject: [GENERAL] pg_xlog d
"Janning Vygen" <[EMAIL PROTECTED]> writes:
> My disk was running full with 100 GB (!) of data/pg_xlog/ files.
The only way for pg_xlog to bloat vastly beyond what it's supposed to be
(which is to say, about twice your checkpoint_segments setting) is if
checkpoints are somehow blocked from happeni
osamente,
>
> Gustavo Franklin Nóbrega
> Infraestrutura e Banco de Dados
> Planae Tecnologia da Informação
> (+55) 14 2106-3514
> http://www.planae.com.br
> - Original Message -
> From: "Janning Vygen" <[EMAIL PROTECTED]>
> To:
> Sent: Monday, March 28, 2005 7
-
From: "Janning Vygen" <[EMAIL PROTECTED]>
To:
Sent: Monday, March 28, 2005 7:19 AM
Subject: [GENERAL] pg_xlog disk full error, i need help
Hi,
i do a nightly CLUSTER and VACUUM on one of my production databases.
Yesterday in the morning the vacuum process was still running afte
Hi,
i do a nightly CLUSTER and VACUUM on one of my production databases.
Yesterday in the morning the vacuum process was still running after 8 hours.
That was very unusal and i didnt know exactly what to do. So i tried to stop
the process. After it didnt work i killed -9 the Vacuum process. I res
