Re: vacuum error

Поиск
Список
Период
Сортировка
От Ed L.
Тема Re: vacuum error
Дата
Msg-id 200703070229.08796.pgsql@bluepolka.net
обсуждение исходный текст
Ответ на Re: vacuum error  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: vacuum error
Список pgsql-general
On Tuesday March 6 2007 11:52 pm, Peter Eisentraut wrote:
> Ed L. wrote:
> > Right.  I'm asking if the fix for this problem is in the new
> > 8.1.8 software, or in the new DB structure resulting from
> > the initdb, or perhaps both.
>
> There is no new DB structure in 8.1.8, which is why you can
> update without initdb.  Consult the release notes for details.

Perhaps my question was not clear enough.  Let me rephrase:  Does
the fix for this problem comes from a *fresh* DB structure
resulting from the initdb, or from a software fix in 8.1.8, or
both?  The answer makes a big difference with a 200gb database.
If it's in the software alone, we can simply restart.  If it's
in the DB structure, we have to migrate 200gb of data from one
PGDATA to another.

Ed


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: postgres slower on nested queries
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: vacuum error