Re: [Solved] Postgres performance problem

Поиск
Список
Период
Сортировка
От Ruben Rubio
Тема Re: [Solved] Postgres performance problem
Дата
Msg-id 46D692CC.7010907@rentalia.com
обсуждение исходный текст
Ответ на Re: Postgres performance problem  (ruben@rentalia.com)
Ответы Re: [Solved] Postgres performance problem  (Decibel! <decibel@decibel.org>)
Re: [Solved] Postgres performance problem  (Mark Lewis <mark.lewis@mir3.com>)
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



Hi ...

Seems its solved. But the problem is not found.

As you may know, I do a vacuum full and a reindex database each day. I
have logs that confirm that its done and I can check that everything was
 fine.

So, this morning, I stopped the website, I stopped database, started it
again. (I was around 200  days without restarting), then I vacuum
database and reindex it (Same command as everyday) . Restart again, and
run again the website.

Now seems its working fine. But I really does not know where is the
problem. Seems vacuum its not working fine?  Maybe database should need
a restart? I really don't know.

Does someone had a similar problem?

Thanks in advance,
Ruben Rubio


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG1pLMIo1XmbAXRboRAqgQAKCkWcZYE8RDppEVI485wDLnIW2SfQCfV+Hj
e8PurQb2TOSYDPW545AJ83c=
=dQgM
-----END PGP SIGNATURE-----

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: ruben@rentalia.com
Дата:
Сообщение: Re: Postgres performance problem
Следующее
От: Decibel!
Дата:
Сообщение: Re: [Solved] Postgres performance problem