Hi.
I´m new here and
i´m not sure if this is the right email to solve my problem.
Well, i have a
very large database, with vary tables and very registers. Every day,too
many operations are perfomed in that DB, with queries that insert, delete and
update. Once a week some statistics are
Anderson Boechat Lopes wrote:
Hi.
I´m new here and i´m not sure if this is the right email to solve my
problem.
Well, i have a very large database, with vary tables and very
registers. Every day, too many operations are perfomed in that DB, with
queries that insert, delete and
Well, i have a very large database, with vary tables and very
registers. Every day, too many operations are perfomed in that DB, with
queries that insert, delete and update. Once a week some statistics are
collected using vacuum analyze.
Have vacuum analyze running once an HOUR if it's very
. :)
- Original Message -
From: Shridhar Daithankar [EMAIL PROTECTED]
To: Anderson Boechat Lopes [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, May 10, 2004 11:21 AM
Subject: Re: [PERFORM] Why queries takes too much time to execute?
Anderson Boechat Lopes wrote:
Hi.
I´m new here
[EMAIL PROTECTED] (Anderson Boechat Lopes) writes:
I´m new here and i´m not sure if this is the right email to
solve my problem.
This should be OK...
Well, i have a very large database, with vary tables and very
registers. Every day, too many operations are perfomed in that DB,
with
On Mon, 10 May 2004, Anderson Boechat Lopes wrote:
Hum... now i think i´m beginning to understand.
The vacuum analyse is recommended to perform at least every day, after
adding or deleting a large number of records, and not vacuum full analyse.
I´ve performed the vacuum full analyse