Skip site navigation (1) Skip section navigation (2)

My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))

From: Bastian Voigt <post(at)bastian-voigt(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
Date: 2007-05-25 12:30:36
Message-ID: 4656D6EC.5060506@bastian-voigt.de (view raw or flat)
Thread:
Lists: pgsql-performance
No, this did not help. The vacuum process is still running far too long 
and makes everything slow. It is even worse than before, cause now the 
system is slow almost all the time while when vacuuming only every 3 
hours it is only slow once every three hours.....


I now did the following. Well, no comment.....


Shellscript A:

while true
do
    psql -U $user -d $database -c "vacuum analyze verbose binary_cache"
    echo "Going to sleep"
    sleep 60
done


Shellscript B:

while true
do
        ps aux > $tempfile
        numwaiting=`grep UPDATE.waiting $tempfile | grep -c -v grep`
        echo "Number of waiting updates: $numwaiting"

        vacuumpid=`grep VACUUM $tempfile| grep -v grep | awk '{print $2}'`
        echo "PID of vacuum process: $vacuumpid"

        if [ $numwaiting -gt 5 ]
        then
                echo "Too many waiting transactions, killing vacuum 
process $vacuumpid..."
                kill $vacuumpid
        fi
        echo "Sleeping 30 Seconds"
        sleep 30
done

-- 
Bastian Voigt
Neum├╝nstersche Stra├če 4
20251 Hamburg
telefon +49 - 40  - 67957171
mobil   +49 - 179 - 4826359



In response to

Responses

pgsql-performance by date

Next:From: Kristo KaivDate: 2007-05-25 12:57:23
Subject: Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
Previous:From: Richard HuxtonDate: 2007-05-25 11:51:30
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group