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/
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 |