PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 19, 2005 2:10 PM
> To: Dann Corbit
> Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED];
> Mark
> Subject: Re: [GENERAL] need an advice on running Database
>
> Do you not recommend autovacuum?
&
[EMAIL PROTECTED] Subject: Re:
[GENERAL] need an advice on running Database
tgresql.org
01/19/2005 04:30 PM
Once per day dump database to disk.
Once per day do a vacuum full.
That should be plenty.
Since there a
> The load will increase in the near future: insert/update/delete
> activity will be at least one in 5 minutes.
>
> What maintenance should I need to do?
You should make sure PostgreSQL is properly tuned for your
hardware and you should run vacuum, say, daily or so.
Karsten
--
GPG key ID E407134
ent by: cc:
[EMAIL PROTECTED] Subject: Re: [GENERAL] need an
advice on running Database
] On Behalf Of Mark
Sent: Wednesday, January 19, 2005 12:41 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] need an advice on running Database
Hi,
I have a small data base ~ 10 tables. each table get
insert/update/delete few times a day. postgresql is running for a
month.
The load will
Hi,
I have a small data base ~ 10 tables. each table get
insert/update/delete few times a day. postgresql is running for a
month.
The load will increase in the near future: insert/update/delete
activity will be at least one in 5 minutes.
What maintenance should I need to do?
Thanks,
Mark.
