Hi, Ezequias,
"Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> wrote:
> What is the interval of time the vacuum will run on my database ?
That depends on your settings and load.
Autovacuum looks at every table, and checks the number of
modifications, as well as the total number of transactions
Ezequias Rodrigues da Rocha wrote:
Could you tell me if only this both options are ok (attach) ?
If I don't mark the interval of vacuuns what will be the interval of
each vacuum ?
The default settings may be fine for you, it depends a bit on how many
insert/updates you get in a given time fra
Just a little question.
What is the interval of time the vacuum will run on my database ?
Ezequias
2006/11/30, Matthew T. O'Connor :
Ezequias Rodrigues da Rocha wrote:
> It is possible to set this up on PgAdmin ?
I don't know.
> I need to shutdown the postgresql service to change this parame
Ezequias Rodrigues da Rocha wrote:
It is possible to set this up on PgAdmin ?
I don't know.
I need to shutdown the postgresql service to change this parameters ?
No, you can just modify the params in postgresql.conf and HUP the server
so that it re-reads the config file, no restart require
Alvaro Herrera wrote:
Ezequias Rodrigues da Rocha wrote:
Hi list,
I would like to know if it is necessary to set my database to
autovaccum if the intent of my DB Manager is do not make any deletion
in any time.
If there is no deletions why autovaccum ok ?
>
You need to vacuum from time to ti
It is possible to set this up on PgAdmin ?
I need to shutdown the postgresql service to change this parameters ?
ps: Your information was very clear for me. Thank you very much.
Ezequias
2006/11/30, Peter Childs <[EMAIL PROTECTED]>:
On 30/11/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Eze
On 30/11/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Ezequias Rodrigues da Rocha wrote:
> Hi list,
>
> I would like to know if it is necessary to set my database to
> autovaccum if the intent of my DB Manager is do not make any deletion
> in any time.
>
> If there is no deletions why autovaccum
Ezequias Rodrigues da Rocha wrote:
> Hi list,
>
> I would like to know if it is necessary to set my database to
> autovaccum if the intent of my DB Manager is do not make any deletion
> in any time.
>
> If there is no deletions why autovaccum ok ?
You need to vacuum from time to time anyway, eve
Hi list,
I would like to know if it is necessary to set my database to
autovaccum if the intent of my DB Manager is do not make any deletion
in any time.
If there is no deletions why autovaccum ok ?
Regards
Ezequias
---(end of broadcast)---
TIP
