Re: new to postgres (and db management) and performance already a problem :-(

От:
Тема: Re: new to postgres (and db management) and performance already a problem :-(
Дата: ,
Msg-id: 074b01c61b1c$538335e0$6402a8c0@iwing
(см: обсуждение, исходный текст)
Ответ на: new to postgres (and db management) and performance already a problem :-(  (Antoine)
Ответы: Re: new to postgres (and db management) and performance already a problem :-(  (Antoine)
Re: new to postgres (and db management) and performance  (Markus Schaber)
Список: pgsql-performance

Скрыть дерево обсуждения

new to postgres (and db management) and performance already a problem :-(  (Antoine, )
 Re: new to postgres (and db management) and performance already a problem :-(  (Andrew Sullivan, )
 Re: new to postgres (and db management) and performance already a problem :-(  (Tom Lane, )
 Re: new to postgres (and db management) and performance already a problem :-(  (<>, )
  Re: new to postgres (and db management) and performance already a problem :-(  (Tom Lane, )
   Re: new to postgres (and db management) and performance  (Markus Schaber, )
 Re: new to postgres (and db management) and performance already a problem :-(  (<>, )
 Re: new to postgres (and db management) and performance already a problem :-(  (Christopher Browne, )
 Re: new to postgres (and db management) and performance already a problem :-(  (<>, )
  Re: new to postgres (and db management) and performance already a problem :-(  (Antoine, )
   Re: new to postgres (and db management) and performance already a problem :-(  (Andrew Sullivan, )
  Re: new to postgres (and db management) and performance  (Markus Schaber, )

> Try a), b), and c) in order on the "offending" tables as they address
> the problem at increasing cost...

thanks alot for the detailed information! the entire concept of vacuum isn't
yet that clear to me, so your explanations and hints are very much
appreciated. i'll defenitely try these steps this weekend when the next full
vacuum was scheduled :-)

best regards,
thomas




В списке pgsql-performance по дате сообщения:

От: Antoine
Дата:
Сообщение: Re: new to postgres (and db management) and performance already a problem :-(
От: Michael Riess
Дата:
Сообщение: Autovacuum / full vacuum