Thread: need an advice on running Database

need an advice on running Database

From

Mark

Date:

19 January 2005, 23:41:06

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

Re: need an advice on running Database

From

"Dann Corbit"

Date:

20 January 2005, 00:30:49

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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] 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 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

Re: need an advice on running Database

From

Richard_D_Levine@raytheon.com

Date:

20 January 2005, 01:15:51

Do you not recommend autovacuum?

Rick



                     
                      "Dann Corbit"
                     
                      <DCorbit@connx.com>            To:       "Mark" <sendmailtomark@yahoo.com>,
<pgsql-general@postgresql.org>             
                      Sent by:                       cc:
                     
                      pgsql-general-owner@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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] 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 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@postgresql.org so that your
      message can get through to the mailing list cleanly

Re: need an advice on running Database

From

Karsten Hilbert

Date:

20 January 2005, 01:24:57

> 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 E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

Re: need an advice on running Database

From

"Dann Corbit"

Date:

20 January 2005, 02:42:33

Yes, autovacuum is better.

I am a fossil from 7.1.3 days.

-----Original Message-----
From: Richard_D_Levine@raytheon.com
[mailto:Richard_D_Levine@raytheon.com]
Sent: Wednesday, January 19, 2005 2:10 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org; pgsql-general-owner@postgresql.org;
Mark
Subject: Re: [GENERAL] need an advice on running Database

Do you not recommend autovacuum?

Rick

                      "Dann Corbit"

                      <DCorbit@connx.com>            To:       "Mark"
<sendmailtomark@yahoo.com>, <pgsql-general@postgresql.org>
                      Sent by:                       cc:

                      pgsql-general-owner@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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] 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 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@postgresql.org so that your
      message can get through to the mailing list cleanly

Re: need an advice on running Database

From

"Uwe C. Schroeder"

Date:

20 January 2005, 03:48:54

-----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@raytheon.com
> [mailto:Richard_D_Levine@raytheon.com]
> Sent: Wednesday, January 19, 2005 2:10 PM
> To: Dann Corbit
> Cc: pgsql-general@postgresql.org; pgsql-general-owner@postgresql.org;
> Mark
> Subject: Re: [GENERAL] need an advice on running Database
>
> Do you not recommend autovacuum?
>
> Rick
>
>
>
>
>                       "Dann Corbit"
>
>                       <DCorbit@connx.com>            To:       "Mark"
> <sendmailtomark@yahoo.com>, <pgsql-general@postgresql.org>
>                       Sent by:                       cc:
>
>                       pgsql-general-owner@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@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] 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 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@postgresql.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-----