On Thu, May 13, 2010 at 7:05 PM, Joao Ferreira
wrote:
>
> Hello all,
>
> I have a hard situation in hands. my autovacuum does not seem to be able
> to get his job done;
>
> database is under active INSERTs/UPDATEs;
> CPU is in aprox 50% iowait for the past 5 hours;
>
vmstat divides io percent (la
On Sun, May 16, 2010 at 1:19 PM, Jaime Casanova wrote:
> On Fri, May 14, 2010 at 5:59 PM, Joao Ferreira gmail
> wrote:
>>
>> For several reasons I can _not_ upgrade pg. I must use 8.1.4 and just
>> live with it. And learn to work around the issues it might bring me.
>> Additionally I can not chan
On Fri, May 14, 2010 at 5:59 PM, Joao Ferreira gmail
wrote:
>
> For several reasons I can _not_ upgrade pg. I must use 8.1.4 and just
> live with it. And learn to work around the issues it might bring me.
> Additionally I can not change the cheap storage we ship in some lower
> end versions of our
On Sun, May 16, 2010 at 12:32 PM, Greg Smith wrote:
> Just make sure you're producing good backups of these systems then. You can
> expect to run into one of the data eating bugs in 8.1 eventually. You'll
> probably have a corrupt database from the sort of fsync issues cheap storage
> introduce
Joao Ferreira gmail wrote:
We have hundreds or thousands of unreachable and unmaintained PG
instalations. I'm totally unable to experiment in each of them. Usage
profile can range from 100 rows per hour to 1000, 10.000, 50.000...
sustained... for several days... or even forever... CPU's and IO
su
Hello guys,
thx for your inputs. I consider you suggestions valid.
We have hundreds or thousands of unreachable and unmaintained PG
instalations. I'm totally unable to experiment in each of them. Usage
profile can range from 100 rows per hour to 1000, 10.000, 50.000...
sustained... for several da
On Thu, May 13, 2010 at 6:23 PM, Scott Marlowe wrote:
> On Thu, May 13, 2010 at 4:05 PM, Joao Ferreira
> wrote:
> >
> > Hello all,
> >
> > I have a hard situation in hands. my autovacuum does not seem to be able
> > to get his job done;
> >
> > database is under active INSERTs/UPDATEs;
> > CPU is
On Thu, May 13, 2010 at 6:23 PM, Scott Marlowe wrote:
> On Thu, May 13, 2010 at 4:05 PM, Joao Ferreira
> wrote:
> >
> > Hello all,
> >
> > I have a hard situation in hands. my autovacuum does not seem to be able
> > to get his job done;
> >
> > database is under active INSERTs/UPDATEs;
> > CPU is
On Thu, May 13, 2010 at 4:05 PM, Joao Ferreira
wrote:
>
> Hello all,
>
> I have a hard situation in hands. my autovacuum does not seem to be able
> to get his job done;
>
> database is under active INSERTs/UPDATEs;
> CPU is in aprox 50% iowait for the past 5 hours;
>
> I've tried turning off autov
Joao Ferreira writes:
> I have a hard situation in hands. my autovacuum does not seem to be able
> to get his job done;
> database is under active INSERTs/UPDATEs;
> CPU is in aprox 50% iowait for the past 5 hours;
> I've tried turning off autovacuum and the effect goes away; I turn it back
> on
Hello all,
I have a hard situation in hands. my autovacuum does not seem to be able
to get his job done;
database is under active INSERTs/UPDATEs;
CPU is in aprox 50% iowait for the past 5 hours;
I've tried turning off autovacuum and the effect goes away; I turn it back
on and it goes back to 5
11 matches
Mail list logo
