Skip site navigation (1) Skip section navigation (2)

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

From: Jamie Fox <jfox(at)directcommerce(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] large object does not exist after pg_migrator
Date: 2009-07-15 21:22:49
Message-ID: (view raw or whole thread)
Lists: pgsql-generalpgsql-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

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



On Wed, Jul 15, 2009 at 9:28 AM, Alvaro Herrera

> 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
> The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-hackers by date

Next:From: Fernando Ike de OliveiraDate: 2009-07-15 21:38:31
Subject: Re: [PATCH] Psql List Languages
Previous:From: Heikki LinnakangasDate: 2009-07-15 21:03:25
Subject: Re: Synch Rep for CommitFest 2009-07

pgsql-general by date

Next:From: Scott MarloweDate: 2009-07-15 21:55:36
Subject: Areca 1680 and RHEL/Centos 5.3 issue
Previous:From: Scott MarloweDate: 2009-07-15 20:24:25
Subject: Re: savepoints in 8.3.7 or whatever...

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group