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

Поиск
Список
Период
Сортировка
От Dronamraju Rajesh
Тема vacuum....errors...killing my PRODUCTION servers
Дата
Msg-id 20001122145209.71286.qmail@web9608.mail.yahoo.com
обсуждение исходный текст
Список 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/

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alfred Perlstein
Дата:
Сообщение: Re: Lack of Performance
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: Re: [GENERAL] Logging