Hello everyone:
I wanted to ask you about how the VACUUM ANALYZE works. is it possible
that something can happen in order to reset its effects forcing to execute
the VACUUM ANALYZE comand again? i am asking this because i am struggling
with a query which works ok after i run a VACUUM ANALYZE,
On 9/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello everyone:
I wanted to ask you about how the VACUUM ANALYZE works. is it possible
that something can happen in order to reset its effects forcing to execute
the VACUUM ANALYZE comand again?
Yes, lots of modifications
On 9/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
Hello everyone:
I wanted to ask you about how the VACUUM ANALYZE works. is it
possible
that something can happen in order to reset its effects forcing to
execute the VACUUM ANALYZE comand again?
Yes, lots of modifications
In response to [EMAIL PROTECTED]:
Hello everyone:
I wanted to ask you about how the VACUUM ANALYZE works. is it possible
that something can happen in order to reset its effects forcing to execute
the VACUUM ANALYZE comand again? i am asking this because i am struggling
with a query
On Tuesday 04 September 2007 11:27:07 [EMAIL PROTECTED] wrote:
Hello everyone:
I wanted to ask you about how the VACUUM ANALYZE works. is it
possible
that something can happen in order to reset its effects forcing to
execute the VACUUM ANALYZE comand again? i am asking this because i
--- [EMAIL PROTECTED] wrote:
Thank you all for the information. I'll get to work on it and see what
happends.
Thanks again
Rafael
I'll chime in with one last thought about excellent resources on Vacuum:
http://www.postgresql.org/docs/8.2/static/sql-vacuum.html
[EMAIL PROTECTED] writes:
I knew that in the long run the VACUUM ANALYZE comand has to be executed
again. My question is if something can happen over night and cause the need
of a new VACUUM ANALYZE (regenerating indexes or other thing related with
performance).
The answer to your question