From: Ruben Rubio Rey <ruben@rentalia.com>
To: Gábriel Ákos <akos.gabriel@i-logic.hu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Posrgres speed problem
Date: Mon, 12 Jun 2006 16:58:49 +0200
Message-ID: <448D8129.9010302@rentalia.com> (raw)
In-Reply-To: <448D7DD9.10400@i-logic.hu>
References: <448D7C81.1000108@rentalia.com>
<448D7DD9.10400@i-logic.hu>
Gábriel Ákos wrote:
> Ruben Rubio Rey wrote:
>
>>
>> Hi,
>>
>> Im having a problem with postgres 8.1.3 on a Fedora Core 3 (kernel
>> 2.6.9-1.667smp)
>>
>> I have two similar servers, one in production and another for testing
>> purposes.
>> Databases are equal (with a difference of some hours)
>>
>> In the testing server, an sql sentence takes arround 1 sec.
>> In production server (low server load) takes arround 50 secs, and
>> uses too much resources.
>>
>> Explain analyze takes too much load, i had to cancel it!
>>
>> Could it be a it a bug?
>> Any ideas?
>
>
> vacuum full analyse the database.
>
>
I use to do it all nights
Its an script with content:
DIREC=/usr/local/pgsql/bin/
DIRLOGS=/var/log/rentalia
LOGBIN=/usr/sbin/cronolog
echo "vacuum vacadb..." | $LOGBIN $DIRLOGS/%Y-%m-%d_limpieza.log
date | $LOGBIN $DIRLOGS/%Y-%m-%d_limpieza.log
$DIREC/vacuumdb -f -v --analyze vacadb 2>&1 | $LOGBIN
$DIRLOGS/%Y-%m-%d_limpieza.log
echo "reindex database vacadb;" | $DIREC/psql vacadb 2>&1 | $LOGBIN
$DIRLOGS/%Y-%m-%d_limpieza.log
date | $LOGBIN $DIRLOGS/%Y-%m-%d_limpieza.log
No errors or warnings are reported. instead repeating it now, I preffer
to wait at tomorrow to check again the logs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ruben@rentalia.com, akos.gabriel@i-logic.hu
Subject: Re: Posrgres speed problem
In-Reply-To: <448D8129.9010302@rentalia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox