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)
Список
Дерево обсуждения
Re: [GENERAL] large object does not exist after pg_migrator Bruce Momjian <bruce@momjian.us>
Re: [GENERAL] large object does not exist after
pg_migrator Alvaro Herrera <alvherre@commandprompt.com>
Re: [GENERAL] large object does not exist after
pg_migrator Bruce Momjian <bruce@momjian.us>
Re: [GENERAL] large object does not exist after
pg_migrator Alvaro Herrera <alvherre@commandprompt.com>
Re: [GENERAL] large object does not exist after
pg_migrator Bruce Momjian <bruce@momjian.us>
Re: [GENERAL] large object does not exist after
pg_migrator Bruce Momjian <bruce@momjian.us>
Re: [GENERAL] large object does not exist after
pg_migrator Bruce Momjian <bruce@momjian.us>
Re: [GENERAL] large object does not exist after pg_migrator Jamie Fox <jfox@directcommerce.com>
Re: [GENERAL] large object does not exist after
pg_migrator Alvaro Herrera <alvherre@commandprompt.com>
Re: [GENERAL] large object does not exist after pg_migrator Jamie Fox <jfox@directcommerce.com>
Re: [GENERAL] large object does not exist after
pg_migrator Alvaro Herrera <alvherre@commandprompt.com>
pg_migrator 8.4.1 alpha 1 released with bug mention Bruce Momjian <bruce@momjian.us>
Re: [GENERAL] large object does not exist after pg_migrator Jamie Fox <jfox@directcommerce.com>
Re: [GENERAL] large object does not exist after
pg_migrator Bruce Momjian <bruce@momjian.us>
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:So did it work?
> 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.The PostgreSQL Company - Command Prompt, Inc.
В списке pgsql-hackers по дате отправления
