vacuum....errors...killing my PRODUCTION servers

From: Dronamraju Rajesh <drajesh80(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuum....errors...killing my PRODUCTION servers
Date: 2000-11-22 14:52:09
Message-ID: 20001122145209.71286.qmail@web9608.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

My first doubt is that for how many updates do we
have to vacuum the database.
I have a production server running postgres
database with around 20000 rows which is very small. I
continously redirect http requests which do a select
with joins of nearly 6 tables. I also do 150 updates
every half an hour to the database.

Does this effect the database heavily ???

sometimes when i do vacuum i get the following
errors:-

NOTICE: Rel campaign_creatives: Uninitialized page
3061 - fixing
NOTICE: Rel campaign_creatives: Uninitialized page
3062 - fixing
NOTICE: Rel campaign_creatives: Uninitialized page
3063 - fixing
NOTICE: Rel campaign_creatives: Uninitialized page
3064 - fixing
NOTICE: Rel campaign_creatives: Uninitialized page
3065 - fixing
NOTICE: Rel campaign_creatives: Uninitialized page
3066 - fixing
NOTICE: Rel campaign_creatives: Uninitialized page
3067 - fixing
NOTICE: Rel campaign_creatives: Uninitialized page
3068 - fixing
NOTICE: Rel campaign_creatives: Uninitialized page
3069 - fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 10) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 11) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 12) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 13) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 15) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 17) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 18) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 1) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 2) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 3) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 4) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 5) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 6) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 7) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 8) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 14) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 16) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 9) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 23) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 22) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 19) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 20) -
fixing
NOTICE: Index campaign_creatives_pkey: pointer to
EmptyPage (blk 3061 off 27) -
fixing

what should be done to avoid these problems??
any help?????

regards
Rajesh

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2000-11-22 20:25:44 Re: [GENERAL] Logging
Previous Message Alfred Perlstein 2000-11-21 23:28:49 Re: Lack of Performance