Re: [Solved] Postgres performance problem - Mailing list pgsql-performance

From Ruben Rubio
Subject Re: [Solved] Postgres performance problem
Date
Msg-id 46D692CC.7010907@rentalia.com
Whole thread Raw
In response to Re: Postgres performance problem  (ruben@rentalia.com)
Responses Re: [Solved] Postgres performance problem
Re: [Solved] Postgres performance problem
List 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-----

Attachment

pgsql-performance by date:

Previous
From: ruben@rentalia.com
Date:
Subject: Re: Postgres performance problem
Next
From: Decibel!
Date:
Subject: Re: [Solved] Postgres performance problem