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  (Joe Maldonado <jmaldonado@webehosting.biz>)
Список 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 по дате отправления:

Предыдущее
От: Joe Maldonado
Дата:
Сообщение: Re: selects during vacuum
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Fw: select null + 0 question