Re: selects during vacuum

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: selects during vacuum
Дата
Msg-id 200307152135.21222.dev@archonet.com
обсуждение исходный текст
Ответ на selects during vacuum  (Joe Maldonado <jmaldonado@webehosting.biz>)
Ответы Re: selects during vacuum
Список pgsql-general
On Tuesday 15 Jul 2003 9:09 pm, Joe Maldonado wrote:
> Hello,
>     Vacuum analyze is taking a really long time on a fairly small table and
> during the time the vacuum is running all "select * from <the table>;"
> seems to hang untill the vacuum is done.  Any help on this matter would
> be greatly appreciated...

Can you post the output of a "verbose" vacuum analyse? That will tell us what
it's up to.

--
  Richard Huxton

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