KaiGai Kohei <kaigai(at)kaigai(dot)gr(dot)jp> wrote:
> Can SELECT lo_create(16385); help this situation?
SELECT lo_create(loid) FROM (SELECT DISTINCT loid FROM pg_largeobject) AS t
would work for pg_migrator.
> I'm not clear whether we also check pg_largeobejct has chunks with same
> LOID on lo_create(). In the regular operation, it shall never happen.
I think the omission is a reasonable optimization.
NTT Open Source Software Center
In response to
pgsql-hackers by date
|Next:||From: Takahiro Itagaki||Date: 2009-12-14 00:40:29|
|Subject: Re: Largeobject Access Controls (r2460)|
|Previous:||From: Simon Riggs||Date: 2009-12-13 22:22:06|
|Subject: Re: Hot Standby, release candidate?|