From: | "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: need an advice on running Database |
Date: | 2005-01-20 00:48:13 |
Message-ID: | 200501191648.13379.uwe@oss4u.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Although with your very little load a manual or cron based vacuum full once a
week will be more than enough.
I'm doing a biweekly vacuum full with one of my customer's machines (an
office application that uses pg as backend) and never had complaints or
problems. That setup makes about 5000 transactions a day - still a very low
load for postgres.
On Wednesday 19 January 2005 03:42 pm, Dann Corbit wrote:
> Yes, autovacuum is better.
>
> I am a fossil from 7.1.3 days.
>
> -----Original Message-----
> From: Richard_D_Levine(at)raytheon(dot)com
> [mailto:Richard_D_Levine(at)raytheon(dot)com]
> Sent: Wednesday, January 19, 2005 2:10 PM
> To: Dann Corbit
> Cc: pgsql-general(at)postgresql(dot)org; pgsql-general-owner(at)postgresql(dot)org;
> Mark
> Subject: Re: [GENERAL] need an advice on running Database
>
> Do you not recommend autovacuum?
>
> Rick
>
>
>
>
> "Dann Corbit"
>
> <DCorbit(at)connx(dot)com> To: "Mark"
> <sendmailtomark(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
> Sent by: cc:
>
> pgsql-general-owner(at)pos 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 are 1440 minutes per day, you are only looking at 288
> transactions per day. Not exactly a taxing transaction load.
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Mark
> Sent: Wednesday, January 19, 2005 12:41 PM
> To: pgsql-general(at)postgresql(dot)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 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.
>
>
>
> __________________________________
> Do you Yahoo!?
> All your favorites on one personal page - Try My Yahoo!
> http://my.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
- --
UC
- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFB7v/NjqGXBvRToM4RAsB5AKCTeELPQA9R/kce4rD78X0mJE+JdQCeIIak
rs7QSe2KHopOt9AkADg+ofU=
=KRuh
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2005-01-20 01:15:37 | Re: Unique Index |
Previous Message | Tom Lane | 2005-01-20 00:36:42 | Re: Why? |