Re: [GENERAL] large object does not exist after pg_migrator

Поиск
Список
Период
Сортировка
От Jamie Fox
Тема Re: [GENERAL] large object does not exist after pg_migrator
Дата
Msg-id de22a6520907151422h525abc48qce68618592754aad@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] large object does not exist after pg_migrator  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Дерево обсуждения
Worked great, vacuumlo finished, a vacuum -full finished amazingly quickly, very exciting.  We're pointing qa apps at it now for testing. 

For some reason though, that index has to be rebuilt after running pg_migrator.

I'll be testing on our 100GB+ prod copy shortly and will let you know if you want.

Thanks,

Jamie


On Wed, Jul 15, 2009 at 9:28 AM, Alvaro Herrera <alvherre@commandprompt.com> wrote:
Jamie Fox wrote:

> Hi -
> REINDEX INDEX pg_largeobject_loid_pn_index;
>
> This seems to have fixed the problem, lo_open of lob data is working again -
> now to see how vacuumlo likes it.

So did it work?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.