<[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 quest
--- [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
http://www.postgresql.org
> 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 thi
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 a
> 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
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
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, h
