-----BEGIN PGP SIGNED MESSAGE-----
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
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,
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
Description: text/x-vcard (246 bytes)
In response to
pgsql-performance by date
|Next:||From: Decibel!||Date: 2007-08-30 17:31:51|
|Subject: Re: [Solved] Postgres performance problem|
|Previous:||From: ruben||Date: 2007-08-30 07:52:16|
|Subject: Re: Postgres performance problem|